Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLiteJ » UltraLiteJ Reference » UltraLiteJ API reference » TableSchema interface


createUniqueIndex method

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.