key syntax

Arguments

In the following descriptions, TableName is the name of the Uniface entity and IndexNumber is the sequential number of the index.

• index—primary keys are created as unique indexes (the default).

  Indexes are named: I_TableName_IndexNumber

  A unique index is created for the primary key, which is named: unique index I_TableName_1

• foxpro—indexes are not supported.

  A primary key is named: primary key (Field1{,Field2...} ) TAG PKEY

• paradox—a primary key is created as an index, with the same name as the table:

  unique index TableName(Field1{,Field2...} )

  Other keys are created with the name of the first field of the index:

  {unique} index Field1(Field1{,Field2...} )

• dosfile—primary key and indexes are created with the names:

  indxnnnn, where nnnn is a 4-digit incremental number starting at 0001 (with leading zeroes), for example:

  create index indx0001 (Field1{,Field2...} )

• primary key—index names are named: I_TableName_IndexNumber

  Primary keys are named: primary key (Field1{,Field2...} )

• constraint— indexes are named: I_TableName_IndexNumber

  Primary keys are of the form: constraint TableName PK primary key (Field1{,Field2...} )

Description

The syntax of indexes and primary keys based on the 'file type' of the data source.