From 6bf859daa6e468d0414e2dceb781ba408f7012de Mon Sep 17 00:00:00 2001 From: Roy Ben Shabat Date: Sun, 7 Mar 2021 11:59:51 +0200 Subject: Drop all tables notes. --- .../Notes/Tango.Notes/DB/Drop All Tables.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 Software/Visual_Studio/Notes/Tango.Notes/DB/Drop All Tables.sql (limited to 'Software/Visual_Studio/Notes/Tango.Notes/DB') diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/Drop All Tables.sql b/Software/Visual_Studio/Notes/Tango.Notes/DB/Drop All Tables.sql new file mode 100644 index 000000000..c7d7cfdfe --- /dev/null +++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/Drop All Tables.sql @@ -0,0 +1,19 @@ +DECLARE @sql NVARCHAR(2000) + +WHILE(EXISTS(SELECT 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE='FOREIGN KEY')) +BEGIN + 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 * from INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME != '__MigrationHistory' AND TABLE_NAME != 'database_firewall_rules')) +BEGIN + SELECT TOP 1 @sql=('DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']') + FROM INFORMATION_SCHEMA.TABLES + WHERE TABLE_NAME != '__MigrationHistory' AND TABLE_NAME != 'database_firewall_rules' + EXEC(@sql) + PRINT @sql +END \ No newline at end of file -- cgit v1.3.1