select
    so.name table_name,sc.name column_name,st.name data_type
from sysobjects so
inner join syscolumns sc on (so.id = sc.id)
inner join systypes st on (st.type = sc.type)
where so.type = 'U'
and st.name IN ('DATETIME','DATE','TIME')

编辑：这也适用于Sybase和任何其他T-sql变体.