drop index

Description

Removes an index from a table in the current database.

Syntax

drop index table_name.index_name

The preceding syntax works only in sybase mode.

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

drop index authors.au_id_ind

Usage

• • You can specify multiple index names in T-SQL, but ODBC supports only a single name per statement. If multiple names are present, multiple ODBC statements are generated.

  • ASE/CIS passes the drop index command to DirectConnect for z/OS as a language event.

  • To get information about existing indexes on a table, use:

    sp_helpindex table_name
    

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF