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

0 vote195 views1 answer
Drop all triggers oracle
SQL
4 votes204 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote182 views1 answer
Oracle free up space in tablespace
SQL
1 vote195 views1 answer
Mysql history command
SQL
0 vote227 views1 answer
Group by max date
SQL
4 votes202 views2 answers
Sql offset
SQL
0 vote191 views1 answer
Database traccar
SQL
0 vote177 views1 answer
Tsql generate rows
SQL
10 votes300 views4 answers
Sql server pagination
SQL
0 vote182 views1 answer
Gcloud check sql
SQL