SoftadminGuide.Table_DateColumns

Type: Table-valued function

Returns all columns for a given table of any of the date/datetime types (date, datetime2, datetimeoffset, smalldatetime, datetime).

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.