no

How to Alter the Sequence Value in Postgresql

This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ: DROP SEQUENCE EMPL...

This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ:
DROP SEQUENCE EMPLOYEE_SEQ_SEQ;
CREATE SEQUENCE EMPLOYEE_SEQ_SEQ start with 2 increment by 1;
The script will set the sequence to 2 and to be incremented by 1.

To alter a table:
alter table EMPLOYEE alter column money type NUMERIC(23, 2);

To alter a table and set a default value:
alter table CRM_PROVIDER alter column RATING_ROUNDING set default 2;

Related

rdbms 3272825424579761483

Post a Comment Default Comments

item