Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jorge Novo Truncate All Tables RE: Truncate All Tables
Eric J Peters
SSC Rookie
Points: 48
More actions
June 3, 2008 at 5:50 am
#823536
What's wrong with this:
EXEC sp_MSforeachtable @command1 = 'alter table ? nocheck constraint all'
EXEC sp_MSforeachtable @command1 = 'delete from ?'
EXEC sp_MSforeachtable @command1 = 'alter table ? check constraint all'