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 vote344 views1 answer
Oracle truncate partition
SQL
0 vote356 views1 answer
Modifier une valeur sql
SQL
0 vote329 views2 answers
Sql trigger difference between for and after
SQL
0 vote333 views1 answer
Php select data from mysql database without column name
SQL
0 vote356 views1 answer
Oracle to_number
SQL
0 vote292 views1 answer
Plsql trigger insert update
SQL
0 vote378 views1 answer
How to compile a function in oracle
SQL
10 votes313 views3 answers
Sql limit results
SQL
13 votes356 views2 answers
Get date from now() mysql
SQL
0 vote346 views1 answer
Display all node label neo4j
SQL