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 vote115 views1 answer
Postgres delete where id in
SQL
53 votes384 views6 answers
How to install mysql ubuntu
SQL
1 vote141 views1 answer
How to start with sql
SQL
0 vote178 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote178 views1 answer
MySQL - How to find word with the most similar beginning
SQL
1 vote161 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
6 votes132 views1 answer
Oracle rank() over (partition)
SQL
0 vote139 views1 answer
Ms sql database data size
SQL
7 votes183 views3 answers
Restore postgres database from sql file
SQL
0 vote202 views1 answer
Updating database in sql
SQL