pink cylinders

More than Four

...there's an axis for that.

Finding the Data Dictionary in DB2

I'm not creating a special "DB2" category for this post :-)

I've been looking for metadata, or some kind of data dictionary similar to those available in MS SQL Server or Oracle DB, to describe the tables and columns in a schema in DB2.

The closest match so far seems to be information in the SYSIBM library:

Specifically:

  • SQLCOLUMNS
  • SQLTABLES

Reference: