SoftadminGuide.ParseParameter_TableJoins

Show allHide all
Type: Table-valued function

Parses the values from a parameter created by SoftadminGuide.Parameter_TableJoins_Create.

Parameters

@JoinParameter mandatory nvarchar(max)
The value of the parameter.

Resultsets

Resultset: Joins

Table count:
Row count:

Columns

Id mandatory any
A unique id, used to map the columns to the correct table.

May join on the Id column of any SoftadminGuide.ParseParameter-object, and the value of a parameter created with SoftadminGuide.Parameter_Table_Create.
ParentId mandatory any
The Id of the table to which this table is joined.
TableObjectId mandatory int
ObjectId of the table from sys.objects.
TableSchemaId mandatory int
SchemaId of the table, from sys.objects.
TableName mandatory any
Fully qualified table name.
ParentColumnName mandatory string
Column name of the parent table in the join.
ReferencedColumnName mandatory string
Column name for this table in the join.
SortOrder mandatory int
Sort order of the join.