Database and Table Information

The next five tables we will look at store information on your tables and extents. They are:

• sysdatabase Databases
• systabnames Tables
• sysextents Tables extents
• sysptprof Tables I/O

Information on all databases on a server: sysdatabases

This view has data on all databases on a server. Have you ever needed to create a pop-up list of databases within a program? This table now allows programs to give users a list of databases to select from without resorting to ESQL/C. The following is the definition of this view:

View sysdatabases
 Column Data Type Description name char(18) database name partnum integer table id for systables owner char(8) user name of creator created integer date created is_logging bitval ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.