create table cache(a,b[,c...k])
|
Group |
Creates a table cache with the name a, the primary key in the first column with name b and names of additional columns c to k.
The return value is a.
Description of Parameters
|
Parameter |
Description |
|
a |
Name of the cache. |
|
b |
Name of the first column (containing the primary key). |
|
c...k |
(optional) Names of additional columns. |
Examples
|
Parameter a |
Parameter b |
Parameter c |
Parameter d |
Result |
|
article |
id |
name |
supplier_Id |
article |
Creates a cache with name article, the column containing the primary key with name id and two other columns named name and support_Id.
References to other caches are specified by character > (see parameter d in the example below).
|
Parameter a |
Parameter b |
Parameter c |
Parameter d |
Result |
|
article |
id |
name |
supplier_Id>supplier |
article |
The column supplier_Id references to the cache with the name supplier.