Sequences are powerful database objects built to generate unique numeric identifiers. While they’re most commonly used to create auto-incrementing primary keys for […]
Read More
Create a No-Gap Sequence in YSQL
Sequences are specialized database objects in YSQL that generate unique numeric identifiers. While they are often used to create auto-incrementing primary keys […]
Read MoreChange the Owner of a Sequence in YSQL
When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreRestart an IDENTITY Column When Truncating a Table
In YSQL the column constraint GENERATED ALWAYS AS IDENTITY allows you to automatically assign a unique number to a column. Example: yugabyte=# […]
Read More