From 674ca83ba9243a9e95a7568c797668dab6aee26a Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:35:25 -0300 Subject: feat: upload files --- Gestor.Application.Migration.Files.20210415_115 .SQL | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 Gestor.Application.Migration.Files.20210415_115 .SQL (limited to 'Gestor.Application.Migration.Files.20210415_115 .SQL') diff --git a/Gestor.Application.Migration.Files.20210415_115 .SQL b/Gestor.Application.Migration.Files.20210415_115 .SQL new file mode 100644 index 0000000..72bca36 --- /dev/null +++ b/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