Unique values

Previous Next

You can specify that a domain must generate unique values. The result is that, in each column based on the domain, for each new record, the application will automatically generate a numerical value that is unique for that record in that column.

The default for the Generate Unique Values domain attribute is No.

If you set Generate Unique Values = Database:

On Oracle or SQL Server, unique values are generated by a database sequence.

On other platforms (ODBC, JDBC, Derby), unique values are generated by a USoft sequence.

 

collapseUnique values: the concept
collapseUnique values and indexes
collapseUnique values generated by an Oracle or Sql Server sequence
collapseUnique values generated by a USoft sequence
collapseUnique values generated by an external component

collapse         Getting the last generated unique value

 

 

See also

Domains