From 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:38:18 -0300 Subject: chore: location --- Gestor.Application.Migration.Files.20210916_176.SQL | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100644 Gestor.Application.Migration.Files.20210916_176.SQL (limited to 'Gestor.Application.Migration.Files.20210916_176.SQL') diff --git a/Gestor.Application.Migration.Files.20210916_176.SQL b/Gestor.Application.Migration.Files.20210916_176.SQL deleted file mode 100644 index eaa4b59..0000000 --- a/Gestor.Application.Migration.Files.20210916_176.SQL +++ /dev/null @@ -1,16 +0,0 @@ -DECLARE @constraint_name NVARCHAR(MAX), @table_name NVARCHAR(MAX), @column_name NVARCHAR(MAX) - -SET @table_name = 'origemcliente' -SET @column_name = 'idtipoorigemcli' - -select TOP 1 @constraint_name = fk.name -from sys.tables tab - inner join sys.columns col on col.object_id = tab.object_id - inner join sys.foreign_key_columns fk_cols on fk_cols.parent_object_id = tab.object_id and fk_cols.parent_column_id = col.column_id - inner join sys.foreign_keys fk on fk.object_id = fk_cols.constraint_object_id - WHERE tab.name = @table_name and col.name = @column_name; - -DECLARE @sqlDrop NVARCHAR(MAX) = N'ALTER TABLE ' + @table_name + ' DROP CONSTRAINT ' + @constraint_name + ';' - -IF @constraint_name IS NOT NULL - exec sp_executesql @sqlDrop \ No newline at end of file -- cgit v1.2.3