/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 vote163 views1 answer
Mysql, how to query the table comments?
SQL
1 vote218 views1 answer
Oracle previous year
SQL
1 vote196 views1 answer
Homebrew install mysql
SQL
0 vote146 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote131 views2 answers
Android sqlite query join
SQL
0 vote151 views1 answer
How to order result of subquery in select
SQL
2 votes171 views2 answers
Mysql add hours to time field
SQL
1 vote295 views1 answer
Sql check roles
SQL
0 vote190 views1 answer
Sp help text in postgresql
SQL
0 vote149 views1 answer
Mysql add to value
SQL