|
View previous topic :: View next topic
|
| Author |
Message |
inforajesh
New User
Joined: 09 Dec 2020
Posts: 20
Location: India
|
|
|
|
Hi,
Is there is any quick way to cross check the SYSIBM tables (Column names). Apart from [https://www.ibm.com/support/knowledgecenter]
Asking this for JOIN query creation with some conditions. I need to know where (in which tables) certain columns are present.
For example, If I Input a specific column name, It should display all the relevant table names where it is present. Something like that..
Thanks in advance. |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2186
Location: USA
|
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| SYSIBM.SYSCOLUMNS? |
|
| Back to top |
|
|
inforajesh
New User
Joined: 09 Dec 2020
Posts: 20
Location: India
|
|
|
|
| Nic Clouston wrote: |
| SYSIBM.SYSCOLUMNS? |
Thank you. |
|
| Back to top |
|
|
inforajesh
New User
Joined: 09 Dec 2020
Posts: 20
Location: India
|
|
|
|
Thank you |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2186
Location: USA
|
|
|
|
| inforajesh wrote: |
Thank you |
Google bless you! |
|
| Back to top |
|
|
|
|
