SELECT TABLE_NAME=b.name, COLUMN_NAME=a.name, CONSTRAINT_NAME=c.name, d.COLUMN_DEFAULT FROM sys.all_columns a INNER JOIN sys.tables b ON a.object_id = b.object_id INNER JOIN sys.default_constraints c ON a.default_object_id = c.object_id INNER JOIN information_schema.columns d ON b.name = d.TABLE_NAME AND a.name = d.COLUMN_NAMEWHERE c.type_desc = 'DEFAULT_CONSTRAINT'