17.10 - MODIFY NO PRIMARY Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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, Vantage 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, the system 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, the system returns an error to the requestor.