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.
USING
ClauseThe 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