List tables and foreign keys

foreignkeys.sql

-- Foreign Keys 
SELECT @@Servername AS ServerName ,
    DB_NAME() AS DB_Name ,
    parent.name AS 'TableName' ,
    o.name AS 'ForeignKey' ,
    o.[Type] ,
    o.Create_date
FROM sys.objects o
    INNER JOIN sys.objects parent ON o.parent_object_id = parent.object_id
WHERE   o.[Type] = 'F'
-- Foreign Keys 
ORDER BY parent.name ,
	        o.name
--OR 
SELECT f.name AS ForeignKey ,
    SCHEMA_NAME(f.SCHEMA_ID) AS SchemaName ,
    OBJECT_NAME(f.parent_object_id) AS TableName ,
    COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName ,
    SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName ,
    OBJECT_NAME(f.referenced_object_id) AS ReferenceTableName ,
    COL_NAME(fc.referenced_object_id, fc.referenced_column_id)
	                                              AS ReferenceColumnName
FROM sys.foreign_keys AS f
    INNER JOIN sys.foreign_key_columns AS fc
    ON f.OBJECT_ID = fc.constraint_object_id
    INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id
ORDER BY TableName ,
	        ReferenceTableName;
	GO