rss search

Delete all tables in SQL

Posted by on Dec 2, 2011 in Handy SQL scripts, SQL Cool Book Secrets | 0 comments
line
Share|

Delete all tables in SQL or drop multiple tables in sql

 

SELECT 'DROP TABLE '+table_name FROM Information_Schema.TABLES
Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter


Leave a Reply

You must be logged in to post a comment.

Devguru.in is Stephen Fry proof thanks to caching by WP Super Cache