sql query to delete all the tables in a database

Solutions on MaxInterview for sql query to delete all the tables in a database by the best coders in the world

Search
showing results for - "sql query to delete all the tables in a database"
Isiah
28 Jun 2017
1BY LOVE
2
3EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
4DECLARE @sql NVARCHAR(max)=''
5
6SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
7FROM   INFORMATION_SCHEMA.TABLES
8WHERE  TABLE_TYPE = 'BASE TABLE'
9Exec Sp_executesql @sql
10
similar questions
delete and drop in sqldelet all record statment sqlhow to drop a database in sql server when it is in usedrop sql statementdelete all value querysql comand for removing data from tablesql delete tabledelete table sqldelete tabletsql delete all rowsdeleting database in sqltsql delete data where column 3ddelete from table sqlsql delete klauselsql delete all values in a columnsql delete all excepthow to delete a table data in sqldelete all records from table except sqldelete all hangfire tables sql queryhow to drop all tables in sqldrop all data from tablesdelete all rows from table sqlremove from table where
queries leading to this page
how to delete all tables in a dbdelete all tables from database sqldelete all tables from database sql server querydrop all tables sqldelete all tables in a database sqlsql server delete all table delete querydelete all tables sqlmssql delete all data from tablesdelete all tables mssqlsql query drop all tablesdelete data from all tables in database sql serversql drop all tables in databasedelete all tables from database sql serversql drop all tables from databasedelete all tables from sql server databasehow to drop all tables in sql serverremove all tables from database sqlsql database to drop all tablessql server delete all tablessql query to delete all the tables in a databasesql delete all from tablemssql all tables deletehow to drop all tables in sql using querydrop all table in database sql serverhow to delete all tables in mssqldelete all the tables in a database sql serverms sql delete all tables in databasedrop all tables sql serversql query to drop all tables in a database in sql clientdrop all tables in database sql serversql query delete all tableshow to drop all tables in sqlsql drop all tablest sql delete all tables in a databasesql server delete all tables in databasesql query to delete all the tables in a database