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

3 votes154 views5 answers
No module named 'MySQLdb'
SQL
-1 vote98 views2 answers
On delete set default sql server
SQL
0 vote138 views1 answer
Check duplicate values plsql
SQL
0 vote237 views1 answer
Drop check command
SQL
1 vote146 views1 answer
Mysql list bigger table
SQL
0 vote149 views1 answer
Postgress append string in select
SQL
11 votes162 views1 answer
Oracle export view ddl
SQL
1 vote156 views2 answers
Mysql trim spaces
SQL
0 vote160 views2 answers
Sqlalchemy default value for column
SQL
0 vote144 views2 answers
Sql select inside select
SQL