|
View previous topic :: View next topic
|
| Author |
Message |
kishore balya
New User
Joined: 17 Oct 2007
Posts: 12
Location: chennai
|
|
|
|
| I want to know the query which displays only the fields in the table. |
|
| Back to top |
|
 |
acevedo
Active User
Joined: 11 May 2005
Posts: 344
Location: Spain
|
|
|
|
| search for SYSIBM.SYSCOLUMNS |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
I realize that you are too important to look at manuals, but as part of the Appendix of every SQL Reference (every version of DB2) there are two, one describes the DB2 catalog tables and the next gives you examples of sql to perform tasks such as you have described .
Also, if you would bother to read a manual, you will find out that there are no fields in DB2 Table Rows, there are only COLUMNs. |
|
| Back to top |
|
|
|
|
