All Forums Database
SAP 73 posts Joined 08/14
11 Nov 2014
ALTER Secondary Index

Hi ,
Please help me with Syntax of all forms of Altering SECONDARY index .
 
Thanks in Advance!
 

SAP
dnoeth 4628 posts Joined 11/04
12 Nov 2014

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

Dieter

fnewbrough 17 posts Joined 05/11
12 Nov 2014

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.

You must sign in to leave a comment.