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 vote204 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote212 views1 answer
Sql how to replace full stop
SQL
42 votes279 views6 answers
Install beautifulsoup
SQL
0 vote224 views1 answer
Postgres change the name of schema
SQL
0 vote270 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote290 views1 answer
Run docker container with database as rds metabase
SQL
0 vote207 views1 answer
Show table details postgresql
SQL
4 votes210 views2 answers
Postgre sql create table
SQL
0 vote300 views1 answer
Sqlalchemy _in array sqlite
SQL
3 votes224 views1 answer
Define REGEXP?
SQL