Data Vault Administrator Guide

Back Next

Alter Index

The Alter Index command drops and adds indexes on columns in the same table.

The ssasql
Alter Index command uses the following syntax:

alter index on <schema name>.<table name>
[drop (column name)]
[add (column name)];

The following table describes the ssasql
Alter Index arguments:

Argument	Description
schema name	Required. Name of the schema that includes the table index that you want to alter.
table name	Required. Name of the table that includes the column you want to alter.
(column name)	Required. Name of the column on which you want to drop or add an index. Use a comma to separate multiple columns.