Drop View with a parameter

[phildude]

I thought this would be a piece of cake, but it hasn't gone as smoothly as I expected. I need to drop a bunch of views, but I don't want to hardcode the drop command since the names change. When I try to do a drop view @viewname it gives me a syntax error - am I missing something?
Phil

 

[tlbroadbent]

Yes, you missed the point that SQL doesn't allow the use of variables to name objects in SQL commands. You must use dynamic SQL to accomplish this task.

Declare @sql varchar(60)
Select @sql='Drop View '+@viewname
Exec(@sql) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[phildude]

Thanks!