PREDEFINE STORED PROCEDURES AND COMMANDS

 SP_DEPENDS TBL_STATE_DETAILS--TEBLE NAME

 SP_HELPTEXT [SYS.DATABASES]

 SP_HELPTEXT [SYS.TABLES]

 SP_HELPTEXT [SYS.PROCEDURES]

 SP_HELPTEXT [SYS.INDEXES]

 SP_HELPTEXT [SYS.VIEWS]

 SP_HELPTEXT [SYS.TRIGGERS]



SELECT * FROM SYS.SYSCOMMENTS

SELECT * FROM SYS.SYSCOMMENTS WHERE TEXT LIKE'%FRAGLIST%'


SELECT * FROM SYS.DATABASES

SELECT * FROM SYS.TABLES

SELECT * FROM SYS.PROCEDURES

SELECT * FROM SYS.VIEWS

SELECT * FROM SYS.INDEXES

SELECT * FROM SYS.TRIGGERS


SELECT * FROM INFORMATION_SCHEMA.COLUMNS

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='DOB'

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='EMP'

SP_HELP EMP--TABLE NAME