programatically dropping a list of table

  cyberpharmacist 11:48 08 Oct 03
Locked

Hi All,

I am trying to programatically drop a list of tables in SQL server, using a variable.

I managed to retrieve a list of table name which i want to drop, storing in a variable, but i can't use the drop table @tablename. i can however return a list of text using print 'drop table '+ @tablename.

please help...

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…