Wednesday, March 21, 2012

HOW to make a database blank through single command?

Is there any way through which all the tables of database can be make blank through a single command.
sumeetOriginally posted by sumeet29
Is there any way through which all the tables of database can be make blank through a single command.

sumeet

I think you should generate the SQL script for the tables, make sure to check the DROP, and CREATE options, besides you should check the Script Indexes, Script triggers, Script PRIMARY keys, and Script FOREIGN keys options.
After running this script all tables will be dropped and created again, so should be blank.
Hope this will help.|||True, thats only the way even I know.

BTW, why do you want to do so?

No comments:

Post a Comment