How to drop all tables in sql

USE Databasename

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

Source: stackoverflow.com

Drop all data from tables

DELETE FROM my_table;			-- all rows, needs a COMMIT to validate
TUNCATE TABLE my_table;			-- all rows, quicker, no possible roolback

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 votes226 views3 answers
Db begintransaction laravel
SQL
0 vote203 views1 answer
Sql change primary key to composite key
SQL
0 vote222 views1 answer
Pgadmin save data greyed out
SQL
0 vote193 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote199 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote266 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote190 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote191 views1 answer
Azure sql server check foreign key
SQL
3 votes213 views1 answer
Start mysql server by terminal in linux
SQL
0 vote200 views1 answer
Mysql update from select on same table
SQL