/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 vote352 views1 answer
Time mysql w3
SQL
10 votes380 views2 answers
Select nextval from sequence oracle
SQL
1 vote364 views1 answer
How to change owner in postgres
SQL
0 vote398 views1 answer
Get primary key of table
SQL
3 votes363 views1 answer
Sql server version query
SQL
0 vote329 views1 answer
Jooq finding lastest value in table
SQL
1 vote344 views1 answer
Oracle stop job
SQL
0 vote351 views1 answer
Mysql select where field is a value
SQL
1 vote352 views1 answer
Select inside insert query
SQL
9 votes368 views1 answer
Mysql check date range
SQL