SoftadminGuide.Table_ColumnDataType

Type: Table-valued function

Gives data type information about a given table column.

Parameters

@ObjectId mandatory int
object_id for a table.
@ColumnId mandatory int
column_id (from sys.columns) for a column.

Resultsets

Resultset: ColumnInfo

Table count: repeated exactly once
Row count: zero or more rows
Columns
user_type_id mandatory int

user_type_id from sys.columns for selected column.

DataType mandatory string

Datatype for selected column