SYS.TABLES
The TABLES
table stores information about the tables in the database, including the name, the owner, the number of columns, the size of a row and the primary key (if any). The TABLES
table also stores information on system tables.
Specific column information is stored in the COLUMNS
table.
Columns
Column name | Type | Description |
---|---|---|
|
|
Table name |
|
|
Name of user who owns the table |
|
|
Owner identification |
|
|
Number of varying-length columns in table |
|
|
Number of nullable columns in table |
|
|
Number of columns in table |
|
|
Length of inline portion of each row |
|
|
Number of LOB columns in the table |
|
|
Number of columns compressed in the table |
|
|
TimesTen identifier for table Matches |
|
|
Table cardinality This value is precise only when no |
|
|
Maximum table cardinality |
|
|
Number of columns in primary key (0 if none) |
|
|
Array of two-byte integer column numbers of primary key, mapped to binary |
|
|
Internal use |
|
|
Persistent XLA status If set, indicates that persistent XLA has been enabled for this particular user table. |
|
|
Total number of partitions in a table. |
|
|
ID of cache group that this table belongs to This flag is nonzero if the table belongs to a cache group. |
|
|
Internal use |
|
|
If Otherwise, value |
|
|
If |
|
|
Future use |
|
|
The ID of the associated permanent table |
|
|
Internal use |
|
|
Number of columns in the replication key described by |
|
|
Column number of the column used for replication's timestamp-based conflict checking |
|
|
Return service for this subscriber with respect to this replication element ' ' ' ' |
|
|
Status of return services 0 - Return services are provided unconditionally. 1 - Return services are provided only by request. This field is ignored if |
|
|
User-defined identifier for table (set with |
|
|
Column numbers used by replication for unique identification of a row Array of two-byte integers, mapped to binary. |
|
|
The access restrictions imposed by replication ' ' ' '
|
|
|
The rule for maintaining the ' ' ' |
|
|
Future use |
|
|
If the table contains compressed columns: the ID of an array, containing the ID's of the corresponding dictionary tables |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Reserved for internal use |
|
|
Distribution scheme for a table in TimesTen Scaleout. Valid values are:
|
|
|
Reserved for internal use |
|
|
Reserved for internal use |