SQL SERVER获取表外键关系

获取数据库表外键关系查询后直接导入其他库

--导出外键
SELECT OBJECT_NAME(f.parent_object_id) namea,
    'ALTER TABLE ' + OBJECT_NAME(f.parent_object_id) +
    ' ADD CONSTRAINT ' + f.name + ' FOREIGN KEY (' + 
    (SELECT COL_NAME(fc.parent_object_id,fc.parent_column_id) 
        FROM sys.foreign_key_columns AS fc
        WHERE fc.constraint_object_id = f.object_id 
        ORDER BY fc.constraint_column_id FOR XML PATH('')) + ') ' +
    ' REFERENCES ' + OBJECT_NAME(f.referenced_object_id) + ' (' +
    (SELECT COL_NAME(fc.referenced_object_id,fc.referenced_column_id) 
        FROM sys.foreign_key_columns AS fc
        WHERE fc.constraint_object_id = f.object_id 
        ORDER BY fc.constraint_column_id FOR XML PATH('')) + ')' nameb
		into ##tabss
FROM sys.foreign_keys AS f 



select * from  ##tabss where namea='tsr_tierbase'