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.