Tuesday, September 16, 2008
Table Data Elements
SELECT COLUMNS.COLNO, COLUMNS.TABSCHEMA, COLUMNS.TABNAME, COLUMNS.COLNAME, COLUMNS.TYPENAME, COLUMNS.LENGTH, COLUMNS.SCALE, COLUMNS.NULLS, COLUMNS.IDENTITY, COLUMNS.GENERATED
FROM SYSCAT.COLUMNS COLUMNS
WHERE (COLUMNS.TABSCHEMA='STAGE') OR (COLUMNS.TABSCHEMA='EDW')
ORDER BY COLUMNS.TABSCHEMA, COLUMNS.TABNAME, COLUMNS.COLNO
FROM SYSCAT.COLUMNS COLUMNS
WHERE (COLUMNS.TABSCHEMA='STAGE') OR (COLUMNS.TABSCHEMA='EDW')
ORDER BY COLUMNS.TABSCHEMA, COLUMNS.TABNAME, COLUMNS.COLNO
Labels: SQL
# posted by DW Helpdesk : 8:44 AM
Subscribe to Posts [Atom]