/SQL/Drop all tables in azure sql database

Drop all tables in azure sql database

while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE='FOREIGN KEY'))
begin
 declare @sql nvarchar(2000)
 SELECT TOP 1 @sql=('ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME
 + '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']')
 FROM information_schema.table_constraints
 WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'
 exec (@sql)
 PRINT @sql
end


while(exists(select 1 from INFORMATION_SCHEMA.TABLES 
    where TABLE_NAME != 'database_firewall_rules' 
    AND TABLE_TYPE = 'BASE TABLE'
    AND TABLE_NAME NOT IN (select name from sys.external_tables)))
begin
 declare @sql1 nvarchar(2000)
 SELECT TOP 1 @sql1=('DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']')
 FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_NAME != 'database_firewall_rules'
    AND TABLE_TYPE = 'BASE TABLE'
    AND TABLE_NAME NOT IN (select name from sys.external_tables)
exec (@sql1)
 PRINT @sql1
end

Source: stackoverflow.com

Similar codes

0 vote132 views1 answer
Unique element in sql
SQL
4 votes119 views2 answers
Oracle unlock user
SQL
0 vote120 views2 answers
Generate sql trigger through ef migration
SQL
-1 vote124 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
4 votes120 views4 answers
Pl sql output
SQL
0 vote124 views2 answers
Python mysql create table if not exists
SQL
0 vote126 views1 answer
Query builder doctrien return sql
SQL
2 votes110 views1 answer
Oracle cpu per session
SQL
0 vote105 views1 answer
Find and replace database table phpmyadmin
SQL
13 votes114 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL