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.