get a column name multiple table in sql server

Question

I know this trick

SELECT * FROM   information_schema.columns WHERE  table_name = 'Table_Name'

i have try this is working wonder full, but i want multiple table column like a product,master and so.

Plz tell me any one how can do this.??????