Showing posts with label structur. Show all posts
Showing posts with label structur. Show all posts

Monday, March 26, 2012

Making Database Empty

Hello Experts,
Can anyone tell me, how can I make SQL server database empty.I mean i need to keep only restore the table structur, no table data.Hi

I imagine going the other way about it would be the best solution. Script the entire db (including all objects etc) and then run the script i.e. create a new empty db rather than delete the data within your existing one.

HTH