sp_MSforeachtable and sp_MSforeachdb

two undocumented Stored Procedures that allow you to process through all tables in a database, or all databases in a SQL Server instance

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.