Dropping tables

[suhash]

Hi Again,

I need to drop a table and create a new one on a trigger.

CREATE TRIGGER TBL_DEL ON dbo.PeerFileListCollection
FOR DELETE
AS
DECLARE @RecordRemoved nvarchar(10)
Declare @TableName nvarchar(10)
declare @SQL nvarchar(100)
Select @RecordRemoved = (Select PeerID From deleted)
set @SQL = ' DROP TABLE ' + 'dbo.'+ltrim(@RecordRemoved)
EXEC(@SQL)

I am using the above code to delete a table, but it is throwing an error. I have tried without "dbo." as well. Still the same.

Thanks in advance

Mal.

 

[TysonLPrice]

What's the error?

 

[suhash]

Hi.

The error is like:

Syntax error near 12.

12 is the name of the table..

Thanks,,

 

[vongrunt]

Table names normally cannot begin with numeric character... have you tried wrapping name into [] ?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[suhash]

Hi..

Yep, u are correct, Sorted the problem out.

Thanks for your time..

Mal.