System Objects
--System Objects OPERATIONS :-
SELECT * FROM SYSOBJECTS
WHERE xtype='U' -- show the user defined tables
SELECT * FROM SYSOBJECTS
WHERE xtype='P' -- show the user defined Procedures
SELECT * FROM SYSOBJECTS
WHERE xtype='F' -- show the user defined Functions
SELECT * FROM SYSOBJECTS
WHERE xtype='T' -- show the Triggers
SELECT * FROM SYSOBJECTS
WHERE xtype='PK' -- show the Primary Keys
SELECT * FROM SYSOBJECTS
WHERE xtype='UQ' -- show the Unique Keys
SELECT * FROM SYSOBJECTS
WHERE xtype='S' -- show the SysTables
SELECT * FROM SYSOBJECTS
WHERE xtype='IT' -- show the Messages(mail)
SELECT * FROM SYSOBJECTS
WHERE xtype='SQ' -- Show the type of Queues from the database