T-SQL Table Column Lookup Query

Here is a quick snippet of T-SQL that I use to find the column names in a given table in SQL Server:

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;

Just replace ‘table_name’ with the name of the table you want to get information about.  This is extremely useful especially when the list of columns is large and I need to access data on a field by field basis for transformation, comparison, etc…