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

1 vote279 views1 answer
Show per page table in xampp
SQL
1 vote283 views2 answers
Login to mysql
SQL
1 vote304 views1 answer
Update foreign key value in mysql
SQL
0 vote295 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote298 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote265 views1 answer
Mysql select row with min date
SQL
5 votes288 views3 answers
Mysql update field from one table to another
SQL
0 vote320 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote288 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote296 views1 answer
Ms sql filter all sympbol
SQL