HSQLDB get next value for IDENTITY column

3 votes

1 answer

2205 views

                          I'm looking for a query to get the next IDENTITY value of a HSQL table. Like if I were to insert a new row into a table that has an auto id column, what value would that turn into.

I did some research and couldn't find anything sadly.

Example:

Suppose I have a table like this:

    CREATE TABLE IF NOT EXISTS Names (
      id INTEGER IDENTITY PRIMARY KEY,
      name VARCHAR(16)
    )

Now I can insert names without having to specify the id. Instead it gets added automatically and increments itself with each insert.  
Now I'd like to get whatever value will be next (if I don't manually set it).

*Edit:*

I think I found a solution:

    SELECT
      IDENTITY_START
    FROM
      INFORMATION_SCHEMA.COLUMNS
    WHERE
      TABLE_NAME = 'NAMES'
      AND COLUMN_NAME = 'ID'
                        

Asked by BrainStone (143 rep)

Jun 13, 2018, 11:15 AM
Last activity: Sep 11, 2019, 05:02 PM

HSQLDB get next value for IDENTITY column

Related Questions