/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 vote198 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote192 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote255 views1 answer
How to rename a database in tsql
SQL
3 votes216 views1 answer
Where id is in list sql
SQL
0 vote275 views1 answer
Offset in postgresql example
SQL
0 vote193 views1 answer
Sql case when exists in another table
SQL
0 vote220 views1 answer
Hallo
SQL
57 votes851 views6 answers
Sql alter table
SQL
0 vote206 views1 answer
Max mysql
SQL
0 vote221 views1 answer
Sql query use select name inside where clause
SQL