To retrieve a list of column information for a table using T-SQL, use the following method:

SELECT
   ORDINAL_POSITION
  ,COLUMN_NAME
  ,DATA_TYPE
  ,CHARACTER_MAXIMUM_LENGTH
  ,IS_NULLABLE
  ,COLUMN_DEFAULT
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_NAME = '<your table>'
ORDER BY
  ORDINAL_POSITION ASC; 

thanks to the original poster.