Data Vault Administrator Guide

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Drop Index

The Drop Index command drops an index on an archived table. When you drop an index, the Data Vault deletes all of the index files for all columns in the table. You must drop and create an index if you repartition an indexed table.

If you archive data to a table that already has an index, you do not have to drop and create the indexes. Use the Renew Index command instead.

The ssasql
Drop Index command uses the following syntax:

drop index on <schema name>.<table name>;

The following table describes the ssasql
Drop Index arguments:

Argument	Description
schema name	Required. Name of the schema that includes the table index you want to drop.
table name	Required. Name of the table from which to drop the index.