View previous topic :: View next topic
|
Author |
Message |
ajaybshukla
New User
Joined: 09 Sep 2008 Posts: 39 Location: india
|
|
|
|
Hi,
I have 271 tables..i want to find one specific Column name from all these tables. Actually i want to know one specific column belongs to which table.
Can anybody help me out.
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
run a few queries on SYSIBM.SYSCOLUMNS and SYSIBM.SYSTABLES |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Ajay,
This query can help you,
Code: |
SELECT TBNAME,NAME,COLTYPE,LENGTH
FROM SYSIBM.SYSCOLUMNS
WHERE NAME = 'yourcolumnname' |
Thank You,
Sushanth Bobby |
|
Back to top |
|
|
|