chore: location

1 files changed, 16 insertions, 0 deletions

diff --git a/Codemerx/Gestor.Application.Migration.Files.20210916_176.SQL b/Codemerx/Gestor.Application.Migration.Files.20210916_176.SQL
new file mode 100644
index 0000000..eaa4b59
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20210916_176.SQL
@@ -0,0 +1,16 @@
+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