Binaryworld - Get field default values of all tables for current database ... [ SQL Server -> T-SQL ]

SELECT
t.Table_Name,
t.Column_Name,
CASE
-- WHEN Column_Default = '(GetDate())' THEN CONVERT(nvarchar(50),GetDate())
WHEN t.Column_Default = 'suser_sname()' THEN suser_sname()
WHEN t.Column_Default = 'suser_name()' THEN suser_name()
ELSE t.Column_Default
END AS Column_Default
FROM
(
SELECT
LEFT ( RIGHT (Column_Default, len(Column_Default) - 1), len(Column_Default) - 2 ) AS Column_Default,
Column_Name,
Table_Name
FROM Information_schema.columns
) AS t
WHERE t.Column_Default IS NOT NULL
ORDER BY Table_Name