SEARCHING THE COLUMN NAME
SELECT A.NAME TABLE_NAME , B.NAME COLUMN_NAME
FROM SYSOBJECTS A, SYSCOLUMNS B
WHERE
A.ID = B.ID
AND B.NAME LIKE 'EXP_DATE'
Searching the column name for enteir database,or searching the column name in table
For Example:
Searching the SCHEME_TYPE Column name for the database
SELECT A.NAME TABLE_NAME , B.NAME COLUMN_NAME
FROM SYSOBJECTS A, SYSCOLUMNS B
WHERE
A.ID = B.ID
AND B.NAME LIKE 'SCHEME_TYPE'
|
No responses found. Be the first to respond and make money from revenue sharing program.
|