/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

51 votes227 views6 answers
Change column name sql
SQL
8 votes144 views2 answers
Grant all privileges database postgres to user
SQL
2 votes130 views3 answers
How to check current user in mySQL
SQL
2 votes128 views1 answer
Oracle apex list connected users
SQL
0 vote123 views1 answer
Mysql function variable
SQL
15 votes127 views1 answer
Mysql int range
SQL
11 votes126 views4 answers
Query DISTINCT
SQL
2 votes128 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote209 views1 answer
Mssql unique key accept nulls
SQL
20 votes124 views5 answers
Sql show tables
SQL