Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE (Delphi) » 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 PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |