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

10 votes324 views2 answers
Mysql alter add foreign key
SQL
0 vote307 views1 answer
Sql server beginning of month
SQL
0 vote304 views1 answer
Sql show all users
SQL
0 vote340 views1 answer
SQL Cut part string
SQL
0 vote319 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote318 views2 answers
Homebrew nysql launch
SQL
8 votes344 views1 answer
Mysql limit rows
SQL
0 vote350 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes307 views1 answer
Ora-00054 find lock
SQL
0 vote300 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL