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 vote308 views2 answers
Sql server set default value equal to auto increment
SQL
2 votes291 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote318 views1 answer
Day of the week sqlite
SQL
13 votes331 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote333 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote342 views1 answer
Date datatype in livesql
SQL
0 vote317 views1 answer
How to find columns with null values in sql
SQL
0 vote320 views1 answer
Sqlite commands
SQL
0 vote355 views1 answer
Postgres list tables and row counts
SQL
6 votes365 views1 answer
Oracle trigger after logon on database
SQL