put_="table"

<do action_="sql" put_="table" schema_="[SCHEMA]" objname_="[TABLE]" data_="{...}"/> updates a table with the specified properties.

Description

put_="table" updates the table properties specified in data_, and only those properties. The caller must be an admin of the schema [SCHEMA].

Syntax

<dynamic>
    <do action_="sql" put_="table"
     schema_="[SCHEMA]"     
     objname_="[TABLE]"
     rename_="[NEW_NAME]"
     reorder_="[COLUMN1][COLUMN2]...[COLUMNn]
     data_="{...}"/>
</dynamic>

Attributes for put_="table"

schema_
The schema where the table to update is located.
objname_
The table to update.
rename_
The new name of the table. This option is valid only if you have rename_schema or drop_schema privileges.
reorder_
A list of all the column names in the table, listed in the desired order. Comma-separated column names are accepted, but risky in case the names contain commas.
data_
The dictionary specified in data_ is the same format as returned by get_="table" and may contain any of the following keys.
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.

Additional information

The parameters for put_="schema", put_="table", or put_="column" may be specified in a package via the data_ attribute, or may be specified directly as attributes to the <do> action. For example, <do action_="sql" put_="schema" objname_=”foo” users_=”bar,baz”/> changes the user list of the schema. This is equivalent to <do action_=”sql” put_=”schema” objname_=”foo” data_=”{users:{'bar','baz'}}”/>).