Dropping an index in SYBASE ASE

[bschechter]

Ladies and Gentlemen,

We want to drop and recreate indexes in powerscript using SYBASE ASE 12.0, but we are having problems with the drop side.

We can create them using:

ls_sql = "CREATE INDEX index1 on dba.table1"
EXECUTE IMMEDIATE :ls_sql;

However the drop SQL does not work:

ls_sql = "DROP INDEX dba.table1.index1"
EXECUTE IMMEDIATE :ls_sql;

Neither does:

ls_sql = "DROP INDEX table1.index1"
EXECUTE IMMEDIATE :ls_sql;

Any help would be greatly appreciated.

Regards,
Brian

 

[golyg]

i asked something similar:
thread669-374871

HTH,

 

[golyg]

i asked something similar,
check out this thread,
thread669-374871

hope it helps,

 

[bschechter]

SYBASE ASE only requires index names to be unique for a particular table. In fact, many tables in our schema have the same index name, so we need to indicate which table.

 

[rawhide58]

Could you create a stored procedure to do all your DB maintenance and just call that proc from within PB?

 

[bschechter]

We definitely could create a stored procedure for this work. The problem is that we do not seem to be able to come up with a syntax for the drop index statement that works even if the user is dba. If you know of a set of stored procedure commands that would work for our situation, it would make my day

Brian