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

0 vote348 views1 answer
SQL query to verify the size of the table
SQL
3 votes332 views1 answer
Force using index oracle
SQL
2 votes331 views1 answer
Add new column not null sql server
SQL
1 vote315 views1 answer
Import local sql into remote mysql
SQL
6 votes340 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote353 views1 answer
Procedure excute monthly oracle
SQL
0 vote323 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
5 votes386 views2 answers
Add days in oracle sql
SQL
0 vote334 views1 answer
Alasql delete column
SQL
3 votes314 views1 answer
Oracle apex message quit website
SQL