General discussion
November 2, 2003 at 08:56 PM
prashantdeshmukh

Deleting tables using store procedure

by prashantdeshmukh . Updated 22 years, 11 months ago

I am trying to delete table using store procedure by taking table name in local varial delcared and putting ling in store procedure as

set @cmdName = ‘Drop table [dbo].[‘ + rtrim(ltrim(@tablename)) + ‘]’
exec @cmdname

Which returns me error, can any one help me?

This discussion is locked

All Comments