create table cache()

Creates a table cache with the name a, the primary key b and the further columns c to k.

The return value of the function is a.

Parameters


Parameter

Description

a

Name of the Table Cache .

b

Name of the first column (primary key).

c...k

(optional) Names of further columns.


Examples


Parameter a

Parameter b

Parameter c

Parameter d

Result

article

id

name

supplier_Id

article

Creates a Table Cache with name article, the column containing the primary key with name id and two other columns named name and support_Id.

Parameter a

Parameter b

Parameter c

Parameter d

Result

supplier

id

supplier_name

supplier_country

article

Creates a Table Cache with name supplier, the column containing the primary key with name id and two other columns named supplier_name and supplier_country.

References

Character > is used to specify references to other Table Caches.


Parameter a

Parameter b

Parameter c

Parameter d

Result

article

id

name

supplier_Id>supplier

article

The column supplier_Id references to the Table Cache with the name supplier. This definition is the prerequisite for later retrieving referenced values with the function "get value from table cache()" (see there).