Teradata Database Message 5735 - 5735 - Analytics Database - Teradata Vantage

Message

The primary index columns may not be altered for a nonempty table.

Explanation

For an ALTER TABLE statement, the set of index columns must not be altered for a non-empty table with a primary index or primary AMP index. Also a nonempty table with no primary index For an ALTER TABLE statement, the set of index columns must not be altered for a nonempty table with a primary index or primary AMP index. Also, a nonempty table with no primary index must not be altered to have a primary index, a nonempty table with a primary index must not be altered to have no primary index, and a nonempty table with no primary index must not be altered to have a primary AMP index. Note that both an empty and a nonempty table with a primary AMP index may be altered to have no primary index.

Generated By

RES modules.

For Whom

End User.

Notes

None

Remedy

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned primary index rules and resubmit the request.