/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 vote166 views1 answer
Homebrew install mysql
SQL
0 vote139 views1 answer
Mysql query with sql to get the next row
SQL
2 votes131 views1 answer
Oracle sql concatenate results into string
SQL
0 vote149 views1 answer
Sql server for loop
SQL
15 votes135 views4 answers
How to get all tables in sql
SQL
0 vote147 views1 answer
Laravel migration sql dump
SQL
0 vote131 views1 answer
Sql constarint
SQL
4 votes140 views2 answers
Oracle unlock user
SQL
0 vote158 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote138 views1 answer
Check if string is a number sql
SQL