Example of a Sybase clustered index
Example of a Sybase clustered index |
|
For example, to create a clustered index called zipidx on a column called zip in a table called rolodex, type:
create clustered index zipidx on rolodex(zip) go
If you see
Msg 1906, Level 16, State 1
Server '', Line 1
Cannot create an index on table 'oanda', because this
table does not exist in database 'pubs2'.
you have tried to index a table that doesn't exist. Most likely,
you mis-typed the table name. Run your index command again,
making sure to type the right table name.
If you see
Msg 1919, Level 16, State 1
Server '', Line 1
Column 'first_name' -- Can't create index on
a column of TEXT or IMAGE datatype.
you've tried to create an index on a column with text of image as its
datatype. That's not allowed, try another column.
If you see
Msg 2760, Level 16, State 1
Server '', Line 1
Column name 'fir' does not exist in target table.
you tried to create an index on a column name that doesn't exist.
Run your index command again, making sure to type the right column
name.