>since I believe this is the default when generating the schema for Turbine
>in other db's. Maybe someone else would like to comment? We could even put
>some comments in the db.props about using IDENTITY if a user so desires.
Actually the following uses IDENTITY (or some form of it)
DB2
HYPERSONIC
INTERBASE
MYSQL
POSTGRESS
the only one missing is ORACLE....
>As far as I can tell, as of ASE 11.x, IDENTITY is the name and the datatype
>must be NUMERIC for ASE to autoincrement.
Correct, from the manuals:
In Adaptive Server Enterprise, each table in a database can have one IDENTITY column.
The data type must be numeric with scale zero, and the IDENTITY column should not
allow nulls.
and for ASA
Adaptive Server Anywhere allows any numeric data type to be an IDENTITY column.
Comments from others are welcomme too on this subject.
Andre.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
