By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,320 Members | 2,109 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,320 IT Pros & Developers. It's quick & easy.

Delete all data in the database

P: n/a
Good day!

Currently I am using MS SQL Server 2000.

I wish to delete all data in the database table except data in login
table and security table. Furthermore, TRUNCATE is done on stand-alone
and child tables, else DELETE is done if table has any foreign key
references (normally refer to parent tables).

Is there any suggested script/stored procedure to automate the
process?

Thanks a million!

Oct 10 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.