InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:51:33 GMT20http://www.sqlservercentral.com/Forums/Topic410257-901-1.aspxHi,I came across undocumented system stored procedure sp_MSForEachTable.Try this to delete all data from all tables in a given database. Please Test it.EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’EXEC sp_MSForEachTable ‘DELETE FROM ?’EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’Thanks ,PremWed, 06 May 2009 13:18:04 GMTpremhttp://www.sqlservercentral.com/Forums/Topic410257-901-1.aspxI'm no SQL expert so correct me if I'm wrong, but...This script gives me syntax errors because some of the table names in my database include spaces, hyphens and other strange characters.So shouldn't we put brackets around the table names, i.e.[code] if exists (select * from sysreferences where rkeyid = object_id(@tn)) /*table referenced by a FOREIGN KEY constraint */ set @sql = 'delete [' + @tn + ']' else set @sql = 'truncate table [' + @tn + ']'[/code]Before someone says "You shouldn't put such characters in table names", the table names are not under my control.Fri, 11 Apr 2008 10:07:23 GMTLars Huttarhttp://www.sqlservercentral.com/Forums/Topic410257-901-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/30274/">Truncating and deleting all tables in a database</A>[/B]Fri, 12 Oct 2007 22:19:47 GMThunchback