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

24 votes156 views5 answers
Sql server insert into select
SQL
0 vote173 views2 answers
Search stored procedures
SQL
1 vote200 views1 answer
Psql connect
SQL
0 vote143 views1 answer
Postgres create database if not exists
SQL
38 votes214 views6 answers
Alter table mysql
SQL
0 vote180 views1 answer
Sql create and grant user access to database
SQL
0 vote151 views1 answer
Copy Table from SQL to CSV
SQL
0 vote197 views1 answer
Mysql equivalent decode oracle
SQL
0 vote207 views1 answer
Selecting from a view SQL
SQL
0 vote147 views1 answer
Declare date variable sql
SQL