/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

6 votes305 views1 answer
SQL insert all columns
SQL
13 votes314 views2 answers
Check if value is null mysql
SQL
0 vote351 views1 answer
How to map sql column to custom names
SQL
-1 vote295 views2 answers
How to display top 50 rows?
SQL
-3 votes350 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote316 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
5 votes331 views4 answers
Select random rows sql
SQL
2 votes322 views1 answer
Get first n letter of department name in sql
SQL
0 vote367 views1 answer
"Hello User Name"
SQL
1 vote337 views1 answer
Search for replace in mysql
SQL