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

3 votes226 views3 answers
How to set up an auto incrementing id db browser
SQL
10 votes277 views4 answers
Sql server pagination
SQL
11 votes245 views1 answer
Oracle insert into where
SQL
1 vote216 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote241 views1 answer
Postgres install unaccent extension
SQL
37 votes226 views3 answers
Duplicate records in sql
SQL
0 vote228 views1 answer
Version and edition of SQL Server Database Engine
SQL
21 votes242 views5 answers
Oracle all tables
SQL
11 votes246 views1 answer
Oracle view source
SQL
0 vote247 views2 answers
Import .sql into postgres db command
SQL