Sql drop all tables

How to drop all tables in sql

USE Databasename

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

Source: stackoverflow.com

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 vote192 views1 answer
Fetching data from mysqldb
SQL
0 vote166 views1 answer
Oracle current date minus 1 day
SQL
0 vote129 views1 answer
Get all employee of salary if more than in sql
SQL
21 votes144 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote166 views2 answers
Create table if not exist
SQL
39 votes219 views4 answers
Select duplicates in sql
SQL
-1 vote130 views1 answer
Add column alter table default value
SQL
0 vote214 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote159 views2 answers
What is rownum in oracle
SQL
2 votes135 views2 answers
Select multiple tables mysql
SQL