SoftadminGuide.ParseParameter_ParentTables

Type: Table-valued function

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

Parameters

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

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

TableObjectId mandatory int

ObjectId of the table from sys.objects.

TableSchemaId mandatory int

SchemaId of the table, from sys.objects.

QuotedFullTableName 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.