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]