SELECT
CONCAT([s].[name],'.',[t].[name]) [Table],
[fk].[name] [ForeignKey],
[c].[name] [Column],
[dc].[name] [DefaultConstraint],
[dc].[definition] [Default]
FROM [sys].[foreign_key_columns] [fkc]
INNER JOIN [sys].[foreign_keys] [fk] ON [fkc].[constraint_object_id] = [fk].[object_id]
INNER JOIN [sys].[columns] [c] ON [c].[object_id] = [fkc].[parent_object_id] AND [c].[column_id] = [fkc].[parent_column_id]
INNER JOIN [sys].[tables] [t] ON [t].[object_id] = [fkc].[parent_object_id]
INNER JOIN [sys].[schemas] [s] ON [s].[schema_id] = [t].[schema_id]
INNER JOIN [sys].[default_constraints] [dc] ON [dc].[parent_object_id] = [fkc].[parent_object_id] AND [dc].[parent_column_id] = [fkc].[parent_column_id]
