>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 >Thanks, this works and shows me lots of defaults in the database.
