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 vote130 views2 answers
Sql server select where date
SQL
6 votes112 views1 answer
Oracle rank() over (partition)
SQL
-1 vote136 views1 answer
Su: Authentication failure mysql
SQL
1 vote119 views1 answer
Sql server select rows by distinct column
SQL
1 vote146 views3 answers
Connection string mysql
SQL
0 vote158 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote126 views1 answer
Too many connections mysql
SQL
1 vote150 views1 answer
Encrypt password postgresql
SQL
3 votes177 views1 answer
Oracle function
SQL
0 vote136 views1 answer
Html css mobile menu arrow dropdown
SQL