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.

Samsung Galaxy S8 review

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

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017