/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 vote359 views1 answer
Radius search with point data in mysql
SQL
0 vote368 views1 answer
Mysql search like but first exact match
SQL
0 vote371 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote343 views1 answer
T-SQL Alter the column data type
SQL
5 votes336 views1 answer
Oracle find foreign key dependencies
SQL
0 vote372 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
2 votes374 views1 answer
Use cases condition in sql query laravel
SQL
5 votes344 views3 answers
String concatenation sql server
SQL
6 votes370 views1 answer
Oracle rank
SQL
0 vote412 views1 answer
Mysql delete entire row on condition
SQL