Click here to Skip to main content
Click here to Skip to main content

Some Important SQL Queries

, 6 Nov 2011
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 ?" ...
We're sorry, but the article you are trying to view was deleted at 6 Mar 2014.

Please go to the Database Table of Contents to view the list of available articles in this section.
| Advertise | Privacy | Mobile
Web04 | 2.8.140814.1 | Last Updated 6 Nov 2011
Article Copyright 2011 by Sangunni
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid