ALTER Secondary Index

Database
SAP
Enthusiast

ALTER Secondary Index

Hi ,

Please help me with Syntax of all forms of Altering SECONDARY index .

Thanks in Advance!

2 REPLIES
Junior Contributor

Re: ALTER Secondary Index

DBMSes usually don't have syntax for altering a index, do DROP INDEX + CREATE INDEX instead.

Teradata Employee

Re: ALTER Secondary Index

The only index that you can modify using an alter is the primary index and the table must be empty to do that.

Example:

ALTER TABLE HSTLD.ADW_CUSTOMER_TYPE2 MODIFY PRIMARY INDEX(CT_ID );

Dieter has provided the only approach for modifying secondary indexes.