␡
- Autonumbering
- ASA: Default
- Transact-SQL: Column Property
- Oracle: CREATE SEQUENCE
- Informix: SERIAL Datatype
- Associated Issues
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Informix: SERIAL Datatype
Informix handles sequential numbers in the CREATE TABLE statement with a special SERIAL datatype. Specifying 0 for the SERIAL column during INSERT makes Informix assign the next sequential number.
Informix
create table testseq
(num serial not null,
name varchar(10) not null)
Table created.
insert into testseq
values ( 0, 'Amir')
insert into testseq
values ( 0, 'Marge')
insert into testseq
values ( 0, 'Tri')
select *
from testseq
num name
1 Amir
2 Marge
3 Tri
[3 rows]