Type:
Table-valued function
Parses the values from a field created by SoftadminGuide.FieldStandard_TableJoins_Create.
Parameters
@JoinField
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.ParseField-object, and the value of a field created with SoftadminGuide.FieldStandard_SqlObjectName_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.
IsLeaf mandatory bit
This is the last table of the supplied join chain.