16.20 - MODIFY NO PRIMARY Option - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The following rules apply to the MODIFY NO PRIMARY option.

  • You can specify MODIFY NO PRIMARY without altering partitioning and the table currently has a column-partitioned primary index or primary AMP index.
  • If you specify MODIFY NO PRIMARY for a SET table, Teradata Database also alters the table to be MULTISET.
  • If you specify MODIFY NO PRIMARY with DROP RANGE#n, ADD RANGE#n clauses, or both, and the table currently has a partitioned primary index without column partitioning, Teradata Database returns an error to the requestor.
  • You can specify an ADD clause for column partitioning, a RANGE_N partitioning expression, or a CASE_N partitioning expression.

    If a row partitioning is not based on a RANGE_N or CASE_N partitioning expression, you cannot specify an ADD clause. Otherwise, Teradata Database returns an error to the requestor.