SoftadminGuide.Table_Columns

Type: Table-valued function

Returns data about all columns for a table.

Parameters

@ObjectId mandatory int
object_id for a table.

Resultsets

Resultset: Columns

Table count: repeated exactly once
Row count: zero or more rows
Columns
Name mandatory sysname

Column name.

column_id mandatory int

column_id from sys.columns.