How to get SQL database objects
SELECT name AS ObjName , crdate AS CreatedDate , refdate AS RefreshDate , CASE [TYPE] WHEN 'AF' THEN 'Aggregate Function (CLR)' WHEN 'C' THEN 'CHECK Constraint' WHEN 'D' THEN 'Default or DEFAULT Constraint' WHEN 'F' THEN 'FOREIGN KEY Constraint' WHEN 'FN' THEN 'Scalar Function' WHEN 'FS' THEN 'Assembly (CLR) Scalar-function' WHEN 'F...