Click here to Skip to main content
12,819,619 members (34,965 online)
Click here to Skip to main content

Some Important SQL Queries

, 6 Nov 2011 CPOL
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.

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170308.1 | Last Updated 6 Nov 2011
Article Copyright 2011 by Sangunni
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid