Mute Duck

Finds columns with the given types.

SELECT
     [System_Object].[name]		AS [Table_Name]
   , [System_Column].[name]		AS [Column_Name]
   , [Column_Type].[name]		AS [Data_Type]
FROM sysobjects AS [System_Object]
INNER JOIN syscolumns AS [System_Column] ON ([System_Object].id = [System_Column].id)
INNER JOIN systypes [Column_Type] ON ([Column_Type].type = [System_Column].type)
WHERE
    [System_Object].[type] = 'U'
AND [Column_Type].[name] IN (
      'DATETIME'
    , 'DATE'
    , 'TIME'
    , 'DATETIME2'
    , 'SMALLDATETIME'
    , 'DATETIMEOFFSET'
)