programatically dropping a list of table

  [DELETED] 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

How to watch the World Cup for free on TV and online

PostPanic's latest short film is a thrilling love letter to film and TV history

Best external graphics cards (eGPUs) for Mac

Les meilleurs navigateurs internet (2018)