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.