Various SQL Server Queries that are helpful

foreign_key_table_references.sql

-- Return referenced table name, and column for each foreign key constraint
DECLARE @TableID INT = OBJECT_ID('SCHEMA.TABLE')

select  OBJECT_NAME(fkc.referenced_object_id) as referenced_table_name, 
        c.name as referenced_column, 
        fk.name as foreign_key_name, 
        OBJECT_NAME(fk.parent_object_id) as owning_table
  from sys.foreign_keys fk
    inner join sys.foreign_key_columns fkc on fk.object_id = fkc.constraint_object_id
    inner join sys.columns c on fkc.referenced_column_id = c.column_id and fkc.parent_object_id = c.object_id
    where fk.parent_object_id = @TableID