var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
i want to know db2 system tables which stores table names and column names. I want to know the query which give column names and their datatype, length of cloumn as query results when i execute it by giving table name in where clause
can any one help?
you will find all DB2 Catalog tables in the SQL Reference. If you're running DB2 LUW, select from SYSCAT.TABLES and SYSCAT.COLUMNS. On OS390, select from SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNS.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors