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

3 votes280 views1 answer
Only join in sql
SQL
0 vote257 views1 answer
Casterar postgres
SQL
0 vote258 views1 answer
Sql server cannot create database diagram
SQL
10 votes267 views5 answers
Between keyword in sql
SQL
0 vote271 views2 answers
Search stored procedures by name
SQL
-1 vote236 views2 answers
Sql query examples
SQL
10 votes284 views4 answers
Else if mysql
SQL
0 vote296 views1 answer
Insert into table with only identity column
SQL
3 votes269 views2 answers
How to modify rows in SQL Server
SQL
33 votes266 views2 answers
Postgres how to add field created at
SQL