Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.2 Online Documentation (MoTW) Revision 3

SQL Index Definition Fields (SQL) (m6915ae+indexfields.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

SQL Index Definition Fields

Field 1 - Index Name

Identifies the name of the index as it must be shown in an SQL query. Case is significant. Refer to the topic Naming Tables, Columns and Indexes.

Field 2 - Created by SQL (Y/N)

Y Indicates that the index was created by an SQL Create-Index command.

N Indicates that the index was initially derived from a Reality file index.

Field 3 - Index Type

0 System use.

2 Item-id index.

3 Ordinary Reality index (sorted index).

Field 4 - Allow duplicates

Y Allows multiple rows per column to have the same value.

N Disallows multiple rows per column from having the same value.

Field 5 - Column name(s)

Lists the columns that are indexed.

Field 6 - Collation(s)

References field 5, indicating whether each column is indexed in Ascending or Descending order.

Field 7 - Reality index name

Specifies the name of the underlying Reality index.

RealityV15.2Revision 3Comment on this topic