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

-1 vote301 views1 answer
How to check table exists or not in postgresql
SQL
1 vote314 views1 answer
Mysql select if empty result
SQL
0 vote308 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote350 views2 answers
Postgres isnull
SQL
0 vote306 views1 answer
Mysql change timestamp on update
SQL
0 vote304 views1 answer
How to create an SQL save method in ruby
SQL
1 vote310 views2 answers
Datetrunc hour snowflake
SQL
1 vote306 views1 answer
Install postgresql on raspberry pi
SQL
0 vote311 views1 answer
Mysql filter based on datediff
SQL
0 vote290 views1 answer
How to remove default in mysql
SQL