Home
Designing databasesThe first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
Designing and Implementing a DatabaseThe HCL OneDB™ Database Design and Implementation Guide provides information to help you design, implement, and manage your HCL® OneDB® databases. It includes data models that illustrate different approaches to database design and shows you how to use structured query language (SQL) to implement and manage your databases.
Basics of database design and implementation
Select data types
Data types
Numeric types
Automatic sequences: BIGSERIAL, SERIAL, and SERIAL8
Alter the next BIGSERIAL, SERIAL, or SERIAL8 number

Alter the next BIGSERIAL, SERIAL, or SERIAL8 number

The database server sets the starting value for a BIGSERIAL, SERIAL, or SERIAL8 column when it creates the column (see Use CREATE TABLE). You can use the ALTER TABLE statement later to reset the next value, the value that is used for the next inserted row.

You can set the next value to any value higher than the current maximum. Doing this will create gaps in the sequence.

If you try to set the next value to a value smaller than the highest value currently in the column you will not get an error but the value will not be set. Allowing the next value to be set lower than some values in the column would cause duplicate values in some situations and is therefore not allowed.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.