SoftadminGuide.Table_AllColumns

Type: Table-valued function

Returns a table with information about all the columns for the given table.

Parameters

@ObjectId mandatory int
Object it of the table.

Resultsets

Resultset: Columns

Table count:
Row count:
Columns
ColumnId mandatory int

The ColumnId from sys.columns.

ColumnName mandatory string

The name of the database column.

DataType mandatory string

The data type Name from sys.types.

SortOrder mandatory int

The sort order, ordered by the ColumnId.