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.
Enjoying Database Administration
15.1.09
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment