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 vote273 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote247 views1 answer
Mysql update sum same table
SQL
0 vote316 views1 answer
Mysql concatenate select results
SQL
1 vote260 views1 answer
Mysql view command
SQL
0 vote272 views1 answer
Sql developer connect to sql server
SQL
1 vote286 views1 answer
Postgresql append array
SQL
2 votes282 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote296 views1 answer
Capabilities of sql select statements
SQL
0 vote251 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote256 views1 answer
AddEntityFrameworkSqlite
SQL