Sql sequence

CREATE SEQUENCE seq_tipo MINVALUE 1;
ALTER TABLE tipo 
ALTER codt SET DEFAULT nextval('seq_tipo');

/*insert into YOUR_COLUMN_NAME VALUES (nextval('seq_tipo'), 'value_2')*/

Sql sequence

CREATE SEQUENCE sequence-name
    START WITH initial-value
    INCREMENT BY increment-value
    MAXVALUE maximum-value
    CYCLE | NOCYCLE;

Source: studytonight.com

Similar codes

1 vote155 views1 answer
Sqlite create index
SQL
0 vote150 views1 answer
Tinydb add table
SQL
0 vote141 views1 answer
MySQL FIND_IN_SET()
SQL
2 votes158 views1 answer
Removing view
SQL
27 votes159 views6 answers
Sql update record
SQL
0 vote97 views1 answer
Print sum of values sql
SQL
1 vote154 views1 answer
Get parameter value in mysql trigger
SQL
0 vote150 views1 answer
Make parameters nullable in sql server
SQL
0 vote131 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote141 views1 answer
Power bi union columns
SQL