get_="table"

<do action_="sql" get_="table" schema_="[SCHEMA]" objname_="[TABLE]" value_="@r"/> populates @r with metadata for the specified table from the specified schema.

Syntax

<dynamic>
    <do action_="sql" get_="table"
     schema_="[SCHEMA]"
     objname_="[TABLE]"
     value_="@r"/>
</dynamic>

Attributes for get_="table"

schema_
The specified schema in which to retrieve the table.
objname_
The name of the table from which to retrieve information.
value_
The information returned by get_="table" is saved as a package to the dynamic variable @r. The package contains eight entries.
name
The name of the table. This name will agree with [TABLE].
path
The 1010data pathname of the MDB table or query underlying the SQL table.
depth
A number that approximates the number of rows in the table for query optimization purposes. It does not automatically follow changes in the underlying table.
segs
A number that approximates the number of segments in the table.
columns
A package with columns containing metadata for each column in the table.
keys
A package with one column (columns) containing information about column groups that constitute keys in the table.
fkeys
A package with three columns (relation, foreign, local) containing information about foreign key relationships in the table.
seginfo
A package with two columns (columns, type) containing information about the segmentation (segby, sortseg) features of the table.