/SQL/SQL Query to delete all the tables in a database

SQL Query to delete all the tables in a database

BY LOVE

EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
DECLARE @sql NVARCHAR(max)=''

SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_TYPE = 'BASE TABLE'
Exec Sp_executesql @sql

Similar codes

0 vote199 views2 answers
Postgres another version
SQL
0 vote241 views1 answer
Add week ending date sql server
SQL
2 votes186 views1 answer
Oracle index size calculation
SQL
0 vote179 views1 answer
Call scalar valued function sql
SQL
1 vote180 views1 answer
Data type and their numeric form
SQL
0 vote190 views1 answer
Left join in codeigniter query builder
SQL
5 votes209 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote250 views1 answer
Isnull in sqlite
SQL
13 votes188 views2 answers
Oracle select into and inner join
SQL
1 vote195 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL