QuerySchemaSources.Add
Syntax variant: Add a query schema table
Syntax:
Parameters:
<AvailableTable> (required)
Name of the table, available table or available nested table obtained from available tables of the query schema.
If a table name was transferred and no table was found with it, an exception is generated.
<Alias> (optional)
Alias of the source to be added. If not specified, the alias of the source to be added will be generated automatically. If the parameter is defined, the alias accuracy will be checked first. If an unavailable alias is specified, an exception containing an error description is generated.
Description of method variant:
Syntax variant: Add a nested query or a temporary table description
Syntax:
Parameters:
<Type> (required)
The parameter must contain a value of the type QuerySchemaNestedQuery.
<Alias> (optional)
The parameter contains the alias that will be assigned to the source. Before the assignment, the alias correctness will be verified. If an improper alias was specified, an exception is generated with the error text.
Description of method variant:
Syntax variant: Add a nested query or a temporary table description
Syntax:
Parameters:
<Type> (required)
The parameter may contain values of the QuerySchemaTempTableDescription type
<Name> (required)
The parameter contains the temporary table name. The alias will be generated automatically. The name might start with "&",
<Alias> (optional)
An alias of the added temporary table. If no parameter is specified, the alias is generated automatically.
Description of method variant:
Returned value:
Description:
Availability: