CODEWITHSUNDEEP
sybasesap-ase
3045 OceanParkway
3045 OceanParkway

Reputation: 11

how to enable/disable index in SYBASE 15.7

I want to enable/disable index in SYBASE 15.7. Do you know the syntax for this?

I tried this: 

    --line to disable index  

        alter table table name disable index index_name  
        go

Upvotes: 0

Views: 2010

Answers (1)

Mike Gardner
Mike Gardner

Reputation: 6651

Sybase ASE 15.7 does not support disabling indexes. You will need to drop and recreate the indexes.

Sybase ASE 15.7 documentation:

Upvotes: 1

Related Questions