psDropIndices

Description

     This program drops indices on tables in a database.  The
indexes on system tables are not touched.  This program will
issue either alter table or drop index commands if the index
is part of a constraint or not.
    Before you drop indices, you might have to first drop referential
integrity constraints with psDropRIConstraints.

Syntax

psDropIndices -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-Rresults_file -Mresults_file_max_size
-Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User Password

-D

Sybase Database

-W

Drop indices on tables belonging to 'owner' only

-N

Drop indices on tables having pattern 'name' [!rs%]

-F

Name of output Korn shell script [standard output]

-R

psSQL results file name [standard output]

-M

Initial max size in bytes for psSQL results file [0]

-O

Options

c

Drop clustered indices too

DSQUERY

When -S is not specified

SYB_USER

When -U is not specified

SYB_PASS

When -P is not specified

SYB_DATABASE

When -D is not specified

PS_SYSMSG_FILE

Name of the tool's messages file