Delete Multiple Tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Delete Multiple Tables

  1. #1
    Join Date
    Nov 2000
    Posts
    178
    Can anyone give me a script to delete multiple tables with a single statement please?.

    AC

  2. #2
    Join Date
    Apr 2001
    Posts
    107
    hi,

    What do you mean by 'multiple tables'?
    Is it all tables in a schema?, do you wich to reuse them afterwards?, etc...

  3. #3
    Join Date
    Nov 2000
    Posts
    344
    You could use EZSQL you right-click them all and then choose 'truncate' or 'drop'. I don't know which one you were after....

    http://www.ezsql.net



  4. #4
    Join Date
    Nov 2000
    Posts
    178
    I mean deleting more than one table without having to type individual commands.

  5. #5
    Join Date
    Nov 2000
    Posts
    344
    there is no way to do that. the closest workaround is to write a script which will create the 'drop table' statements, then save the output of that script to a file, then run the resulting script.


  6. #6
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I agree there is no way you can delete all the tables in one command.You will need to write a script and execute the script to delete the tables or best you can use dyanmic sql to generate a script and exexute it

    Regards
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width