SoftadminGuide.ParseField_ParentTables

Type: Table-valued function

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

Parameters

@ParentTablesField mandatory nvarchar(max)
The value of the field.

Resultsets

Resultset: Tables

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 the direct parent of.

TableObjectId mandatory int

ObjectId of the table from sys.objects.

TableSchemaId mandatory int

SchemaId of the table, from sys.objects.

TableName mandatory string

Fully qualified table name.

ParentColumnName mandatory string

Column name of the foreign key column in the parent table.

ReferencedColumnName mandatory string

Column name of column referenced by the foreign key in this table.

SortOrder mandatory int

Sort order of the selected table.