15.00 - DDL Statements for Specifying Individual Table-Level Integrity Checking Levels - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

DDL Statements for Specifying Individual Table‑Level Integrity Checking Levels

You define base table‑specific integrity checking values using the appropriate CREATE or ALTER statement drawn from the following list.

  • CREATE HASH INDEX
  • CREATE JOIN INDEX
  • CREATE TABLE
  • ALTER TABLE
  • Note that the secondary index subtables defined using either a CREATE INDEX request or a CREATE TABLE request automatically inherit their CHECKSUM I/O integrity level from their parent table or join index. See SQL Data Definition Language for information about specifying disk I/O integrity using these statements.