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 vote167 views1 answer
Oarcale list objects
SQL
0 vote169 views1 answer
C# check if mysql query modified rows
SQL
0 vote128 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
2 votes215 views1 answer
Mysql shell insert into
SQL
4 votes214 views1 answer
Postgresql create table with index
SQL
4 votes230 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
12 votes167 views2 answers
Delete entries in postgresql
SQL
20 votes159 views1 answer
Get all table name in sql through php
SQL
24 votes181 views4 answers
Mssql get all table names
SQL
6 votes160 views2 answers
How to copy data in sql
SQL