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.