SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

2-8

ALTER INDEX Statement

Considerations for ALTER INDEX

Examples of ALTER INDEX

The ALTER INDEX statement modifies an SQL/MX index by changing one or more file

attributes of the index or by renaming the index. See Database Object Names on

page 6-13.

ALTER INDEX is an SQL/MX extension.

Syntax Description of ALTER INDEX

index

is the ANSI logical name of the index to alter, of the form:

[[catalog-name.]schema-name.]index

where each part of the name is a valid SQL identifier with a maximum of 128

characters. For more information, see Identifiers on page 6-56 and Database

Object Names on page 6-13.

RENAME TO new-index-object-name

changes the logical name of the index within the schema.

new-index-object-name

specifies the new ANSI name of the index. The new ANSI name of the index

cannot be qualified. However, the renamed index will remain in the current

catalog and schema.

ALTER INDEX [[catalog-name.]schema-name.]index alter-action

alter-action is:

RENAME TO new-index-object-name

|ATTRIBUTE[S]attribute [,attribute ]...

attribute is:

{ALLOCATE num-extents | DEALLOCATE}

{AUDITCOMPRESS | NO AUDITCOMPRESS}

| {CLEARONPURGE | NO CLEARONPURGE}

| MAXEXTENTS num-extents

Note. RENAME TO changes the redefinition timestamp of the affected index and the

associated base table. However, the remaining indexes of the table are not affected.