Count All Objects of a database
Source: https://blogs.msdn.microsoft.com/buckwoody/2007/09/24/script-of-the-day-count-all-objects-in-a-database/ SELECT 'Count' = COUNT(*) , 'Type' = CASE type WHEN 'C' THEN 'CHECK constraints' WHEN 'D' THEN 'Default or DEFAULT constraints' WHEN 'F' THEN 'FOREIGN KEY constraints' WHEN 'FN' THEN 'Scalar functions' WHEN 'IF' THEN 'Inlined table-functions' WHEN 'K' THEN 'PRIMARY KEY or UNIQUE constraints' WHEN 'L' THEN 'Logs' ...