SQL Query to listout column name From Table

Here i am discussing about the SQL Query to get the list of all column name in existing table in database.

The below query are used :

Select 
        TABLE_NAME, COLUMN_NAME 
From INFORMATION_SCHEMA.COLUMNS 
Where TABLE_NAME='table_name'