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.
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).
I think I found a solution:
SELECT IDENTITY_START FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'NAMES' AND COLUMN_NAME = 'ID'