How to count No.of Tables,stored procedures,views,functions,triggers,primary keys,etc...

SELECT
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='U') AS [TABLES],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='P') AS [STORED PROCEDURE],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='X') AS [EXTENDED STORED PROCEDURE],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='V') AS [VIEW],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='IF') AS [FUNCTIONS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='TR') AS [TRIGERS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='C') AS [CHECK CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='D') AS [DEFAULT CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='F') AS [FOREIGN KEY CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='PK') AS [PRIMARY KEY CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='UQ') AS [UNIQUE CONSTRAINTS]