/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

33 votes168 views2 answers
Postgres how to add field created at
SQL
0 vote162 views1 answer
Name '_mysql' is not defined
SQL
0 vote197 views2 answers
Get item by composite primary key mysql
SQL
0 vote214 views1 answer
Eliminate zero from integer mysql
SQL
0 vote194 views1 answer
Mssql + bit + in python orm
SQL
5 votes229 views1 answer
Oracle ora-00054 resource busy
SQL
1 vote275 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote180 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote137 views1 answer
How to connect sql server using ip address in c#
SQL
3 votes182 views1 answer
Two select sql
SQL