Some Important SQL Queries

There are a few useful, but undocumented stored procedures in SQL Server:sp_MSforeachtableFor example:Delete all tables from a databaseEXEC sp_MSforeachtable @command1 = "DROP TABLE ?" Select all the rows form all the tableEXEC sp_MSforeachtable @command1 = "SELECT * FROM ?" ...