Creates a new unique index.
IndexSchema TableSchema.createUniqueIndex( String index_name ) throws ULjException
index_name The name of index. The specified name must be a valid SQL identifier.
Each index key must be unique or contain a null in at least one column.
Unlike the columns in unique key constraints, columns in a unique index are allowed to be null. A foreign key can reference either a primary key or a unique key but a foreign key can not reference a unique index.
The IndexSchema assigned to the created unique index with the specified name.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |