SoftadminGuide.ParseField_Columns

Type: Table-valued function

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

Parameters

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

Resultsets

Resultset: Columns

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.

ColumnName mandatory string

The name of the database column.

ColumnId mandatory int

The ColumnId from sys.columns.

DataType mandatory string

The data type Name from sys.types.

SortOrder mandatory int

The sort order, first ordered by the join order for tables and secondary by the ColumnId.