/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

3 votes308 views1 answer
Unsigned int in mysql
SQL
1 vote323 views1 answer
Alter constraint in sql
SQL
6 votes296 views4 answers
Delete table sqlite
SQL
0 vote315 views1 answer
Running percentage of total postgres
SQL
1 vote298 views1 answer
Sql padd let with zeros
SQL
6 votes307 views2 answers
What is non relational database
SQL
0 vote297 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote304 views1 answer
Add multiple row table pl sql
SQL
0 vote301 views1 answer
Mysql url data type
SQL
0 vote296 views1 answer
Cast float mysql
SQL