/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

4 votes183 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote188 views1 answer
Null column as zero in mysql
SQL
1 vote198 views1 answer
Mysql text to decimal
SQL
0 vote188 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote180 views1 answer
Query string starts with vowels
SQL
4 votes168 views3 answers
Create database in mySQL
SQL
0 vote180 views2 answers
Update all columns in one update
SQL
-1 vote186 views1 answer
Sql set max value in column
SQL
0 vote190 views1 answer
Mysql update set sum
SQL
3 votes188 views1 answer
Oracle rollback
SQL