Empty Database

[dylanwhite]

Hi,

I want to keep a database but empty it's contents. Basically so i have an empty Database ready to be re populated. Can someone give me the correct T-SQL for this please.

Thank you in advance

 

[ecobb]

If there are just a few tables in the database, you can use this for each table:

Truncate Table YourTableName


If you have too many tables to truncate individually, I would suggest scripting the database and recreating a new database from the script. The script will generate an exact blank copy of your database.

Hope This Helps.