/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

1 vote145 views2 answers
Oracle list service names
SQL
0 vote140 views1 answer
Postgresql comandos basicos
SQL
0 vote136 views1 answer
Mysqldump ignore table
SQL
8 votes140 views3 answers
Connect python to mysql
SQL
0 vote154 views1 answer
Least spark sql
SQL
0 vote323 views1 answer
Power bi connect to postgresql
SQL
0 vote156 views1 answer
Safe mysql
SQL
0 vote144 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote148 views1 answer
Sql ignore
SQL
0 vote136 views1 answer
Add sqlite3 in lumen
SQL