Table Information
Use this page to view general information about a table and table statistics.
The information displayed depends on the type of table.
- Type
- The type of table. Table includes standard
tables and system catalog tables. The other types are raw table, external
table, public synonym, private synonym, view, and tables that contain TimeSeries columns.
The Type can also be a collection. The Tasks and Task Status tabs and the actions in the Schema Manager plug-in do not apply to collections. The collection attributes are displayed for information only.
- Row size
- The row size in bytes.
For standard, raw, and system catalog tables, synonyms, views, and tables that contain TimeSeries columns, the page displays the following additional information:
- Dbspace
- The dbspace that contains the table or Fragmented Table if the table is a fragmented table that resides in multiple dbspaces.
- Interval fragmentation
- For tables that are created with a Date-range fragmentation or
a Range fragmentation scheme. The column that
is used as the basis for the fragmentation. The integer interval or
the date-range interval. Store in shows the
dbspaces where the data is stored.
The rolling window options are the threshold: maximum fragments or the maximum total size of the table, the purge policy for the oldest fragment: detach or discard, and the intervals that are eligible for removal. This information is displayed for Informix® 12.10.
- Lock level
- Lock mode for the table: page, row, or table.
- Data pages
- The number of data pages that have ever been initialized by the database server.
- First extent
- The size of the first extent in kilobytes.
- Next extent
- The size of the next extent in kilobytes.
- Compressed
- An indicator of whether compression is enabled for the table. This information is displayed for Informix 11.50.xC6 or later.
- Row auditing
- An indicator of whether the table is included in row-level auditing when selective row-level auditing is enabled for the database server. This information is displayed for Informix 11.70.
- Grid table
- An indicator if the table is in a grid table list. Grid queries can be run against this table in the context of the grid. This table can be altered only in the context of the grid. This information is displayed for Informix 12.10.
- Grid
- The name of the grid if the table is in a grid table list. A table can be in the grid table list for only one grid. This information is displayed for Informix 12.10.
- View definition
- For a view, the CREATE VIEW statement that defines the view.
- Load tasks
- The number of load tasks that are submitted or saved for the table. The task loads data from an external source into the database table. For information about the tasks and the task status, click the Tasks and Task Status tabs. This information is displayed for Informix 11.50.xC6 or later.
- Unload tasks
- The number of unload tasks that are submitted or saved for the table. The task unloads data from the database table to an external table. For information about the tasks and the task status, click the Tasks and Task Status tabs. This information is displayed for Informix 11.50.xC6 or later.
For external tables, the page displays the following additional information. This information is displayed for Informix 11.50.xC6 or later.
- External table type
- Delimited, fixed-width, or Informix format.
- Maximum errors
- The number of errors that are allowed before the database server stops the load task.
- Reject file
- The location of the reject file. Rows that have conversion errors during a load task or that violate check constraints on the external table are written to the reject file.
- Field delimiter
- For delimited external tables, the character that separates the fields in the external table.
- Record delimiter
- For delimited external tables, the character that separates the records in the external table.
- Date format
- The format of date columns in the external table. The date format is the value for the DBDATE option in the CREATE EXTERNAL TABLE statement.
- Money format
- The format of money columns in the external table. The money format is the value for the DBMONEY option in the CREATE EXTERNAL TABLE statement.
- Mode
- Deluxe or express. Deluxe mode is required for loading data into standard tables. The deluxe mode updates indexes, performs constraint checking, and evaluates triggers as data is inserted into the table. In deluxe mode, you can access and update the table that is being loaded. Express mode is required for loading data into raw tables. Express mode is faster than deluxe mode, but it is less flexible. In express mode, you cannot update the table or read the new data entries until the load operation is completed.
- Recognize the escape
- For delimited and fixed-width external tables, an indicator of whether the escape character is recognized. The escape character marks ASCII special characters in ASCII-text-based files. The backslash (\) is the default escape character, indicating that the next character is a literal character in the data, rather than a special character.
- File Name
- The location of the external files that are opened when the external table is used. The word before the file name indicates whether the file is on disk or on a named pipe.