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

22 votes139 views6 answers
Create sql table
SQL
-1 vote157 views1 answer
Sql show custom constraints
SQL
14 votes141 views1 answer
Oracle alter table add column not null
SQL
5 votes144 views1 answer
Mysql count newlines in field
SQL
1 vote130 views1 answer
SQL date part only of datetime
SQL
0 vote131 views1 answer
Create synonym for dblink in oracle
SQL
0 vote133 views1 answer
Select last 2 characters sql
SQL
4 votes126 views2 answers
Sql table
SQL
1 vote127 views1 answer
Order by oracle
SQL
0 vote135 views1 answer
Object of class mysqli_result could not be converted to string
SQL