/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 vote287 views2 answers
Dbms transaction tutorialspoint
SQL
38 votes322 views6 answers
Alter table mysql
SQL
2 votes565 views1 answer
Oracle virtual column
SQL
34 votes292 views5 answers
Oracle alter table add column
SQL
52 votes469 views6 answers
Rename column sql
SQL
0 vote272 views1 answer
Rabbitmq ui not working
SQL
21 votes268 views3 answers
Average sql
SQL
1 vote279 views1 answer
Oracle select first result
SQL
1 vote326 views1 answer
Drop colum oracle 18c
SQL
14 votes278 views2 answers
Oracle export trigger ddl
SQL