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