Why only 249 non-clustered index can be created in sybase ASE? Any
specific reason?

Thanks in advance

On Aug 9, 7:41*am, Subind <subind... (AT) gmail (DOT) com> wrote:
Check the output from

dbcc traceon(3604)
dbcc serverlimits
go

....

Table, Index related limits

Max number of columns in a table/
view : 1024
Max number of indexes on a
table : 250
Max number of user-keys in a single index on an unpartitioned
table : 31
Max number of user-keys in a single local index on a partitioned
table : 31
Max number of user-keys in a single global index on a partitioned
table : 30
Max number of referential constraints per
table : 192
Max number of keys in a referential integrity
constraint : 16
....

Index ID 0 == the table.
250 - 1 = 249

QED

You are almost, but not quite, 100% correct shookster.

That is 205 minus 1 for the Clustered Index, not 0 for the Heap.

Regards
Derek