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.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

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

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…