drop index (core)

Removes an index from a table in the current database.

Syntax

Transact-SQL Syntax

drop index table_name.index_name
[, table_name.index_name]...

ODBC Syntax

DROP INDEX index_name

Parameters

table_name – is the table in which the indexed column is located. The table must be in the current database.
index_name – is the name of the index to be dropped.

Examples

Example 1 – drops authors index.
```
drop index authors.au_id_ind
```

Usage

You can specify multiple index names in Transact-SQL, but ODBC supports only a single name per statement. If multiple names are present, multiple ODBC DROP statements are generated.
Adaptive Server/CIS passes the drop index command to the DirectConnect server as a language event.
To get information about existing indexes on a table:
```
sp_helpindex table_name
```

Parent topic: Transact-SQL Commands

Created November 29, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com