how to find COLUMN,DATA_TYPE,table name in a database

SELECT        COLUMN_NAME, DATA_TYPE
FROM            INFORMATION_SCHEMA.COLUMNS
WHERE        (TABLE_NAME = 'EMP')

how to find table name in a database
SELECT        TABLE_NAME
FROM            INFORMATION_SCHEMA.COLUMNS