/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

5 votes215 views1 answer
Oracle get ddl
SQL
4 votes253 views1 answer
Postgresql list sequences
SQL
2 votes175 views1 answer
Ssh mysql port forwarding
SQL
0 vote184 views1 answer
Python list from sql
SQL
1 vote224 views2 answers
Sql now - 1 day
SQL
0 vote199 views1 answer
What is top n result in sql
SQL
4 votes180 views4 answers
Date less than in sql
SQL
-1 vote176 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote187 views1 answer
Sql developer search all packages for text
SQL
3 votes235 views1 answer
How to uninstall microsoft sql server
SQL