deeejay icon

DB2 - View table column headings

deeejay | PRO | 07/31/14 09:54:00 PM UTC | 0 ⭐ | 339 👁️ | Never ⏰ | []
SQL |

210 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
SELECT * 
FROM QSYS2.SYSCOLUMNS 
WHERE TABLE_NAME = 'HRJPOS7'
 
SELECT COLUMN_NAME, COLUMN_HEADING, COLUMN_TEXT, DATA_TYPE, LENGTH
FROM QSYS2.SYSCOLUMNS 
WHERE TABLE_NAME = 'PPPDEPT'
AND TABLE_SCHEMA = 'PP#FILE'

Comments