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

1 vote280 views1 answer
Sql delete all values in a column
SQL
4 votes326 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote295 views1 answer
Python connect microsoft sql server
SQL
2 votes325 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote281 views2 answers
Cascade syntax in sql
SQL
0 vote277 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote295 views1 answer
Sql_inner_join
SQL
27 votes306 views5 answers
Add column in table
SQL
0 vote308 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
23 votes311 views6 answers
How to create table in sql
SQL