/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

0 vote277 views2 answers
Py sqlite if entry exists
SQL
0 vote253 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
4 votes245 views1 answer
Oracle show error line number
SQL
1 vote302 views1 answer
Oracle plan hash value
SQL
8 votes270 views2 answers
Grant all privileges database postgres to user
SQL
0 vote318 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote242 views1 answer
Mysql percentage of total
SQL
5 votes272 views1 answer
Mysql last day of next month
SQL
16 votes248 views3 answers
Order by sql query
SQL
0 vote256 views1 answer
Sql server delete records with specific date
SQL