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.