From 225aa1499e37faf9d38257caabbadc68d78b427e Mon Sep 17 00:00:00 2001
From: Lucas Faria Mendes <lucas.fariamo08@gmail.com>
Date: Mon, 30 Mar 2026 12:29:41 -0300
Subject: decompiler.com

---
 .../Gestor.Application.Migration.Files.20210415_115-.SQL | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 Decompiler/Gestor.Application.Migration.Files.20210415_115-.SQL

(limited to 'Decompiler/Gestor.Application.Migration.Files.20210415_115-.SQL')

diff --git a/Decompiler/Gestor.Application.Migration.Files.20210415_115-.SQL b/Decompiler/Gestor.Application.Migration.Files.20210415_115-.SQL
new file mode 100644
index 0000000..72bca36
--- /dev/null
+++ b/Decompiler/Gestor.Application.Migration.Files.20210415_115-.SQL
@@ -0,0 +1,16 @@
+DECLARE @constraint_name NVARCHAR(MAX), @table_name NVARCHAR(MAX), @column_name NVARCHAR(MAX)
+
+SET @table_name = 'ciacontato'
+SET @column_name = 'idfonetipo'
+
+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
-- 
cgit v1.2.3

