Creating an Index
Overview
To create an index on one or more columns of a table,
use the CREATE INDEX statement.
|
General form, CREATE
INDEX statement:
CREATE <UNIQUE> INDEX index-name
ON table-name (column-name-1<,
...column-name-n>);
UNIQUE
is a keyword that specifies
that all values of the column(s) specified in the statement must be
unique.
index-name
specifies the name
of the index to be created. If you are creating an index on one column
only, then index-name must
be the same as column-name-1.
If you are creating an index on more than one column, then index-name cannot
be the same as the name of any existing column or index in the table.
table-name
specifies the name of the table ... |
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
