incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele <>
Subject re: How to tell that a rows is UNIQUE ?
Date Wed, 18 May 2011 19:26:16 GMT
Hi exxos,

I don't quite understand your question.
What do you consider a unique column?

Some databases allow integer columns that are automatically populated from a sequence (e.g.
identity columns in Microsoft SQL).

Another feature in Microsoft sql is the data type "uniqueidentifier" which is a guid that
will be automatically generated for each row.

For those two cases Empire-db offers the data types DataType.AUTOINC and DataType.UNIQUEID.

The exact implementation however is database specific. The Oracle driver e.g. will create
a number column and automatically create a sequence for AutoInc columns (on DDL generation).

Does this answer help you?


Exxos wrote:
> from: exxos [] 
> to:
> re: How to tell that a rows is UNIQUE ?
> Hello,
> At the colomn declartion in DBTable, how to tell that a colomn is unique ?
> (I'm not talking about primaries keys)
> Regards,
> exxos.

View raw message