Table Type

 
Snapshot Level
Table

 
Logical Data Grouping
table

 
Monitor Switch
Table

Resettable

No

 
Event Type
Table

 
Logical Data Grouping
table_event

Element Name
Element Type

table_type
information

Description:  The type of table for which information is returned.

Usage:  You can use this element to help identify the table for which information is returned. If the table is a user table or a system catalog table, you can use "Table Name" and "Table Schema Name" to identify the table.

The type of table may be one of the following:

• User table.
• User table that has been dropped. The table type will only be updated after the changes are committed (either explicitly or implicitly).
• Temporary table. Information regarding temporary tables is returned, even though the tables are not kept in the database after being used. You may still find information about this type of table useful.
• System catalog table.
• Reorganization table. A table created and used by the database manager while performing a reorganization of another table.