SQL Get Table Column Names as output

SELECT

   ORDINAL_POSITION

  ,COLUMN_NAME

  ,DATA_TYPE

  ,CHARACTER_MAXIMUM_LENGTH

  ,IS_NULLABLE

  ,COLUMN_DEFAULT

FROM  

  INFORMATION_SCHEMA.COLUMNS

WHERE  

  TABLE_NAME = '<table_name>'

ORDER BY

  ORDINAL_POSITION ASC;