Aşağıdaki kod ile mevcut veritabanınızdaki Foreign Key’lerin ALTER scriptini oluşturabilirsiniz.

SELECT  ('ALTER TABLE [' + OBJECT_NAME(f.parent_object_id) + ']'
        + ' ADD CONSTRAINT ' + '[' + f.name + ']' + ' FOREIGN KEY ' + '('
        + COL_NAME(fc.parent_object_id, fc.parent_column_id) + ') '
        + 'REFERENCES [' + OBJECT_NAME(f.referenced_object_id) + '] ('
        + COL_NAME(fc.referenced_object_id, fc.referenced_column_id) + ');'
        + CASE WHEN is_disabled = 1 THEN ' ALTER TABLE [' + OBJECT_NAME(f.parent_object_id) + '] NOCHECK CONSTRAINT [' + f.name + ']' ELSE '' END) AS Scripts
        -- AS SET_DISABLE
FROM    .sys.foreign_keys AS f
        INNER JOIN .sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id

Comments

comments