programatically dropping a list of table

  cyberpharmacist 11:48 08 Oct 2003
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.

Elsewhere on IDG sites

iMac Pro review

3D illustrator Billelis on how to promote yourself on social media

iMac Pro review

Apple Music : comment obtenir 3 mois gratuits ?