/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 vote96 views1 answer
Output table plsql
SQL
0 vote103 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote99 views1 answer
Update from select join
SQL
1 vote110 views1 answer
Oracle create as select
SQL
0 vote107 views1 answer
Sql count null values in all columns
SQL
15 votes111 views2 answers
Select Options
SQL
3 votes97 views1 answer
Sql multiple column index
SQL
0 vote92 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote104 views1 answer
Apex for oracle 11g
SQL
38 votes183 views6 answers
Ubuntu install mysql client
SQL