![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for Delphi 6 » SQL Reference » CREATE INDEX Statement |
CREATE [UNIQUE] [NOCASE] INDEX [IF NOT EXISTS] index_name ON table_reference (column_name [ASC or ASCENDING | DESC or DESCENDING] [, column_name...]) [COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE]] [NOKEYSTATS]
UNIQUE
NOCASE
(column_name [[ASC |ASCENDING] | [DESC | DESCENDING]] [, column_name...])
COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE
NOKEYSTATS
CREATE INDEX CustDate ON Orders (CustNo, SaleDate DESC) COMPRESS DUPBYTE
CREATE UNIQUE NOCASE INDEX "Last Name" ON Employee (Last_Name) COMPRESS FULL
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |