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_id
mandatory
int
column_id from sys.columns.