Sql drop all tables

How to drop all tables in sql

USE Databasename

SELECT  'DROP TABLE [' + name + '];'
FROM    sys.tables

Source: stackoverflow.com

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

Sql drop all tables

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

Source: stackoverflow.com

Similar codes

5 votes210 views4 answers
Rollback to in sql
SQL
0 vote211 views1 answer
Oracle to_number
SQL
3 votes216 views2 answers
Oracle apex view logs
SQL
0 vote187 views1 answer
Rabbitmq service not starting
SQL
0 vote205 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote208 views1 answer
Mariadb maximum left join
SQL
0 vote211 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote196 views1 answer
Mysql history command
SQL
0 vote219 views2 answers
How to take recent row without limit in mysql
SQL
4 votes208 views3 answers
How to describe a table in sqlite3
SQL