Background story: I do not know why, but I really have a problem remembering create and drop index syntax. So I'll put it here where I can easily find it.
Task: Write a syntax reletated to index
Solution: There is simple create index syntax:
create index index_name on table_name (column_name1, column_name2)
and there is drop index syntax:
drop index table_name.index_name
Remark: Full create and drop index syntax are given below. For more information about index (and other Sybase) commands, look atReference Manual Volume 2:Commands.