Column values may show information related to a Teradata temporal table or an ANSI temporal table.
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 |