When we require executing same T-SQL command for all the tables, we can use this stored procedure.
Many times we need to run drop/truncate command for all tables or REINDEX all tables, at that point instead of the manual script we can use this stored procedure.
1 2 3 4 5 6 7 8 9 10 11 | -- 1. Truncate all tables of current database: EXEC sp_MSforeachtable 'TRUNCATE TABLE ?' -- 2. Check the count of all tables: EXEC sp_MSforeachtable 'TRUNCATE TABLE ?' -- 3. Drop all tables of current database: EXEC sp_MSforeachtable 'DROP TABLE ?' -- 4. REINDEX all tables of current database: EXEC sp_MSforeachtable 'DBCC DBREINDEX(' '?' ')' |