Name	Value
NAME	SQLI_PRIMARY_KEY
DESCRIPTION	A chosen set of columns which uniquely identify a table. In the relational model (as in set theory) the columns of a primary key are not ordered. In SQLI they must be, in order to map to the quasi- hierarchical model of M globals. FileMan subfiles (multiples) have a primary key element for each parent plus one for the subfile. Each contains a pointer to its primary key table element (SQLI_TABLE-ELEMENT), a sequence and a column in the local base table (SQL_COLUMN).

Name

Value

NAME

SQLI_PRIMARY_KEY

DESCRIPTION

A chosen set of columns which uniquely identify a table.
In the relational model (as in set theory) the columns of a primary key
are not ordered. In SQLI they must be, in order to map to the quasi-
hierarchical model of M globals.
 
FileMan subfiles (multiples) have a primary key element for each parent
plus one for the subfile. Each contains a pointer to its primary key table
element (SQLI_TABLE-ELEMENT), a sequence and a column in the local base
 table (SQL_COLUMN).

SQLI_PRIMARY_KEY (1.5218) FILE (1)