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 vote274 views1 answer
Allow null in psql
SQL
0 vote296 views1 answer
Psql create usr
SQL
0 vote276 views1 answer
Example database query
SQL
0 vote286 views2 answers
How to drop mili second in sql
SQL
3 votes238 views1 answer
Sql several or
SQL
0 vote293 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote268 views1 answer
Creating a simple notify in postgresql
SQL
0 vote252 views1 answer
Drop all tables db2
SQL
0 vote259 views3 answers
Osx stop mysql service
SQL
0 vote245 views1 answer
Query on date sqlite flutter
SQL