Display Database Structures

There are several ttIsql commands that display information on database structures.

The most useful commands are summarized below:

• describe - Displays information on database objects.
• cachegroups - Displays the attributes of cache groups.
• repschemes - Reports information on replication schemes defined in the currently connected data source.
• dssize - Reports the current sizes of the permanent and temporary database memory regions.
• tablesize - Displays the size of tables that have been analyzed with the ttComputeTabSizes tool.
• monitor - Displays a summary of the current state of the database.