-
Can anyone give me a script to delete multiple tables with a single statement please?.
AC
-
hi,
What do you mean by 'multiple tables'?
Is it all tables in a schema?, do you wich to reuse them afterwards?, etc...
-
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
-
I mean deleting more than one table without having to type individual commands.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|