/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

2 votes160 views1 answer
Get first 2 letter in sql
SQL
2 votes190 views3 answers
Sql server: how to concatenate column data using comma
SQL
2 votes169 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
10 votes166 views4 answers
How to alter table name in mysql
SQL
1 vote178 views1 answer
Mysql return if it contains
SQL
0 vote163 views1 answer
Sqlite update only if greater
SQL
0 vote165 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote193 views1 answer
Mysql join only one column
SQL
1 vote116 views1 answer
Full text index mysql
SQL
3 votes160 views1 answer
Select without null values sql
SQL