Vertica

Vertica driver is built-into Querona and is ready to use.

IDENTITY columns

Querona honors a T-SQL IDENTITY ( seed , increment ) column declaration on Vertica with full fidelity — any seed and increment are accepted — by emulating it with a named sequence:

• Querona creates a sequence named qua_identity_<table>_<column> in the table’s schema, configured with the declared seed and increment, and assigns it as the column’s default value.

• DROP TABLE also drops the backing sequence.

• If a sequence with that name already exists, the CREATE TABLE fails with an error.

• Explicit identity inserts are not supported on Vertica: SET IDENTITY_INSERT is not available for Vertica-backed identity tables.

CREATE TABLE dbo.Product (
    Id    int          IDENTITY(1000, 10) PRIMARY KEY,
    Code  nvarchar(20) NOT NULL
);

See also

• CREATE TABLE

• Create a connection

• Vertica documentation