>>EXEC sp_MSForEachTable 'EXEC sp_columns ''?''' >>>>
SELECT OBJECT_NAME(syscolumns.Id) AS Table_Name, syscolumns.name AS Column_Name, OBJECT_NAME(syscomments.id) AS Default_Constraint_Name FROM syscomments INNER JOIN syscolumns ON syscomments.id = syscolumns.cdefault AND syscolumns.cdefault > 0 ORDER BY OBJECT_NAME(syscolumns.Id),syscolumns.name