FirebirdSQL logo
The USING Clause

The USING clause allows you to specify a user-defined name for the index that is created automatically and, optionally, to define the direction of the index — either ascending (the default) or descending.

PRIMARY KEY

The PRIMARY KEY constraint is built on one or more key columns, where each column has the NOT NULL constraint specified.The values across the key columns in any row must be unique.A table can have only one primary key.

  • A single-column primary key can be defined as a column-level or a table-level constraint

  • A multi-column primary key must be specified as a table-level constraint