field

I want to have a list of the fileds of a table on the basis of field type.Means only fileds of int type or varchar type this way.Is it possible?You probably want something like:SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 'dba_holiday' = TABLE_NAME
AND 'datetime' = DATA_TYPE-PatP