System Catalog

Here are three little queries that you can use to gather information about your database:

SELECT * FROM SYSCAT.COLUMNS WHERE TABSCHEMA = 'SchemaName';

This will display information about all of the columns in SchemaName.

SELECT * FROM SYSCAT.TABLES WHERE TABSCHEMA = 'SchemaName';

This will display information about all of the tables in SchemaName.

SELECT * FROM SYSCAT.INDEXES WHERE TABSCHEMA = 'SchemaName';

This will display information about all of the indexes in SchemaName.

I will address each of these SYSCAT tables in depth in the days and weeks to come.