How to drop all tables in sql

USE Databasename

SELECT  'DROP TABLE [' + name + '];'
FROM    sys.tables

Source: stackoverflow.com

Drop all data from tables

DELETE FROM my_table;			-- all rows, needs a COMMIT to validate
TUNCATE TABLE my_table;			-- all rows, quicker, no possible roolback

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

2 votes56 views1 answer
Mysql admin u root p password change password
SQL
12 votes146 views4 answers
How to drop all tables in postgresql
SQL
1 vote111 views1 answer
Import sql file mysql commadn line
SQL
0 vote113 views1 answer
How to set up an anonymous function to variable in swift
SQL
2 votes95 views1 answer
Sqlplus clear screen
SQL
0 vote134 views1 answer
SQL Where-Klausel
SQL
57 votes263 views5 answers
How to create a new user in postgresql
SQL
0 vote109 views1 answer
Duplix print in Smartforms
SQL
4 votes231 views2 answers
Sql display today's date
SQL
0 vote162 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL