|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| • |
Esimerkki
1:
|
|
|
|
CREATE TABLE tuotteet (
|
|
|
|
TUOTE_ID INTEGER
|
|
|
|
GENERATED ALWAYS AS
|
|
IDENTITY
|
|
|
|
START WITH 100
|
|
|
|
INCREMENT 1
|
|
|
|
MINVALUE 100
|
|
|
|
NO MAXVALUE
|
|
|
|
NO CYCLE,
|
|
|
|
... )
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| • |
Esimerkki
2:
|
|
|
|
CREATE SEQUENCE
|
|
|
osanumero AS INTEGER
|
|
|
START WITH 1
|
|
|
|
INCREMENT BY 1
|
|
|
|
MAXVALUE 100000
|
|
|
|
MINVALUE 1
|
|
|
|