/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 vote163 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote166 views1 answer
Execute sql stored procedure in powershell
SQL
19 votes180 views3 answers
Grant mysql
SQL
0 vote170 views1 answer
Sqlcmd no headers
SQL
0 vote157 views1 answer
Postgres call view
SQL
3 votes165 views1 answer
Postgres count distinct
SQL
3 votes185 views2 answers
Mysql import gz
SQL
-2 votes222 views1 answer
Trunc in sql
SQL
1 vote164 views1 answer
Oracle list datafiles in tablespace
SQL
2 votes179 views3 answers
Mysql list tables by size
SQL