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

23 votes236 views6 answers
How to create table in sql
SQL
0 vote208 views1 answer
Sql select maximum column with other columns returned
SQL
3 votes245 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote225 views1 answer
Drop unique
SQL
1 vote248 views1 answer
Isnull sql server
SQL
0 vote206 views8 answers
Convert sql query to linq online
SQL
0 vote250 views1 answer
For row in sql database python loop
SQL
1 vote188 views1 answer
Ms sql how to see active job current run time
SQL
3 votes213 views1 answer
Sql replace character in string in all records
SQL
4 votes205 views1 answer
Oracle show error line number
SQL