chore: location

1 files changed, 0 insertions, 16 deletions

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