how to find TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE of a table

SELECT        TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE

FROM            INFORMATION_SCHEMA.COLUMNS

WHERE        (TABLE_NAME = 'EMP')