get_="schema"

<do action_="sql" get_="schema" objname_="[SCHEMA]" value_="@r"/> populates @r with a specified schema.

Syntax

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

Attributes for get_="schema"

objname_
The specified schema in which to retrieve information.
value_
The information returned by get_="schema" is saved as a package to the dynamic variable @r. @r contains seven entries.
name
The name of the schema. This always agrees with the specified [SCHEMA].
desc
An arbitrary string that can be used to add information about the schema.
tables
A package with columns containing metadata for each of the tables in the schema.
views
A package with columns containing metadata for each of the SQL views in the schema.
procs
A package with columns containing metadata for stored procedures in the schema.
udfs
A package with columns containing metadata for user-defined functions in the schema.
tvfs
A package with columns containing metadata for table-valued functions (parameterized view) in the schema.