Re: HOW to make a database blank through single command??
Originally posted by sumeet29
Is there any way through which all the tables of database can be make blank through a single command.
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.