razorsql firebird autoinc column creation

the trigger depends on a single column and a single generator.TField.ProviderFlags =, or when the column is part of a primary key.įireDAC automatically recognizes limited sets of the Firebird auto-incrementing columns, and sets them to dtIntXxx, when:.TField.DataType = ftAutoInc (TFDAutoIncField) when dtInt32 or dtUInt32 otherwise one of the numeric ftXxxx data types.INTEGER PRIMARY KEY AUTOINCREMENT data typeĪutomatic as auto-incrementing data type when ExtendedMetadata is True.įireDAC automatically recognizes a column of an auto-incrementing data type, and defines it to dtIntXxx. Automatic as auto-incrementing data type.Oracle 12c and higher: GENERATED AS IDENTITY data type.Sequence and BEFORE INSERT FOR EACH ROW trigger.Firebird 3.0: GENERATED BY DEFAULT AS IDENTITYĪutomatic and manual specifying.

Depending on the DBMS, the auto-incrementing fields may be implemented either using a special IDENTITY (or similar) column data type, or using a generator (or a sequence) and a table trigger:Īutomatic as auto-incrementing data type. That works for immediate updates, as well as for cached updates. FireDAC allows the insertion of a new record with an auto-incrementing column and getting back a new value of this column.

Razorsql firebird autoinc column creation