Remove all tables from database using MSSQL query

sql Share on :

MSSQL contains a store procedure - sp_MSforeachtable that can be used to remove or drop all tables from the database.

-- First remove all foreign key constraints between tables
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

-- Execute below query to drop tables from database
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

In the code snippet, we first remove all the foreign key constraints binding from the tables and then remove all tables by executing the sp_MSforeachtable store procedure.

Search Index Data (The code snippet can also be found with below search text)

drop all tables MSSQL

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Select only year from date field MSSql query
MSSQL query to insert value which contains apostrophe or single quote
Fetch all data from table SQL
Drop table SQL query
Truncate table SQL query
Delete from table SQL query
UPDATE TABLE SQL query