Some of the column values show information related to a Teradata temporal table or an ANSI temporal table. For more information about these tables, see Teradata Vantage™ ANSI Temporal Table Support , B035-1186 and Teradata Vantage™ Temporal Table Support , B035-1182 .
For more information about the possible values for the TimeDimension column, see "TimeDimension Column."
Corresponding Tables
The corresponding tables for DBC.ShowColChecksV are:
- DBC.DBase
- DBC.TVFields
- DBC.TVM
The corresponding tables for DBC.ShowColChecksV[X] are:
- DBC.DBase
- DBC.Owners
- DBC.RoleGrants
- DBC.Roles
- DBC.TVFields
- DBC.TVM
Possible Values for TTCheckType
| Value | Description |
|---|---|
| A | ANSIQUALIFIER The TTCheckType column returns the value A when the qualifier is ANSIQUALIFIER for column-level CHECK constraints.
|
| NULL | No transaction-time dimension |
| C | CURRENT TRANSACTIONTIME |
Possible Values for VTCheckType
| Value | Description |
|---|---|
| A | ANSIQUALIFIER. The VTCheckType column returns the value A when the qualifier is ANSIQUALIFIER for column-level CHECK constraints.
|
| NULL | No valid-time dimension |
| C | CURRENT VALIDTIME |
| S | SEQUENCED VALIDTIME |
| N | NONSEQUENCED VALIDTIME |