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

No comments:

Post a Comment