How to get all field names & Table schema in a table using SQL query

Solutions :
select [column_name],* from information_schema.columns
 where table_name = 'Table name' order by [column_name]