/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

1 vote311 views2 answers
Restart identity cascade
SQL
1 vote290 views4 answers
Fatal database postgres does not exist
SQL
0 vote319 views1 answer
List column names of multiple tables psql
SQL
1 vote336 views1 answer
Tsql update datetime
SQL
0 vote317 views1 answer
User defined variables in sql
SQL
4 votes300 views2 answers
DB::transaction
SQL
36 votes381 views6 answers
Change column data type sql
SQL
9 votes327 views4 answers
Oracle get table column names
SQL
1 vote300 views1 answer
Sql oracle update multiple rows
SQL
0 vote323 views1 answer
SQL Server rename foreign key constraint
SQL