Need Help With A Query That Retrieves DEFAULT Constraints

Hi guys,

I am trying to write a query that seaches for all DEFAULT constraints in a database and prints the column with the default value, the value of the default, and the name of the default constraint.

So far I have the two queries that let me get all the information I need.

SELECT Name FROM sysobjects
WHERE xtype = 'D'

SELECT column_default, column_name FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_default IS NOT Null


I am unable to merge them into one query. I cannot seem to find a commun field to both of them.

Many thanks in advance.
Darkneon