select count(*),case xtype when 'P' then 'Stored Procedure' when 'C' then 'CHECK constraint'when 'D' then 'DEFAULT constraint'when 'F' then 'FOREIGN KEY constraint'when 'L' then 'Log'when 'PK' then 'PRIMARY KEY constraint'when 'RF' then 'Replication filter stored procedure'when 'S' then 'System table'when 'TR' then 'Trigger'when 'U' then 'User table'when 'UQ' then 'UNIQUE constraint'when 'V' then 'View'when 'X' then 'Extended stored procedure'when 'FN' then 'Function'when 'IF' then 'In-lined table-function 'when 'SQ' then 'Service queue'when 'IT' then 'Internal table'when 'TF' then 'Table function'else xtype endfrom sysobjects group by xtype
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: