Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jorge Novo Truncate All Tables RE: Truncate All Tables
Jorge Novo-@ETLDEVDBA
Ten Centuries
Points: 1265
More actions
November 17, 2008 at 5:23 am
#899256
If not references are present on the tables:
EXEC sp_MSForEachTable 'truncate TABLE ? ' will be enough to truncate all tables.
the sp_MSForEachTable replace the ? for the actual table Name.