deeejay

DB2 - View table column headings

Jul 31st, 2014
385
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. SELECT *
  2. FROM QSYS2.SYSCOLUMNS
  3. WHERE TABLE_NAME = 'HRJPOS7'
  4.  
  5. SELECT COLUMN_NAME, COLUMN_HEADING, COLUMN_TEXT, DATA_TYPE, LENGTH
  6. FROM QSYS2.SYSCOLUMNS
  7. WHERE TABLE_NAME = 'PPPDEPT'
  8. AND TABLE_SCHEMA = 'PP#FILE'
Advertisement
Add Comment
Please, Sign In to add comment