/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 vote351 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
1 vote355 views2 answers
Mysql remove first and last character from string
SQL
0 vote371 views1 answer
Psql show db
SQL
1 vote380 views1 answer
How to select random rows from a table
SQL
0 vote359 views1 answer
Raiserror with nowait
SQL
0 vote346 views2 answers
Sql 2 way of select unique
SQL
0 vote346 views1 answer
Drop a field in psql django
SQL
0 vote351 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote310 views1 answer
Postgres division by zero
SQL
3 votes347 views1 answer
Oracle revoke
SQL