get a column name multiple table in sql server

  SELECT T.NAME AS [TABLE NAME], C.NAME AS [COLUMN NAME],
  P.NAME AS [DATA TYPE], P.MAX_LENGTH AS[SIZE],
  CAST(P.PRECISION AS VARCHAR) +'/'+ CAST(P.SCALE AS VARCHAR) AS [PRECISION/SCALE]  
  FROM SYS.OBJECTS AS T JOIN SYS.COLUMNS AS C ON T.OBJECT_ID=C.OBJECT_ID JOIN  
  SYS.TYPES AS P ON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID WHERE
  T.TYPE_DESC='USER_TABLE';

  Or
  SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME,
  ORDINAL_POSITION, COLUMN_DEFAULT, DATA_TYPE,
  CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION,
  NUMERIC_PRECISION_RADIX, NUMERIC_SCALE, DATETIME_PRECISION FROM  
  INFORMATION_SCHEMA.COLUMNS

  select o.name,c.name from sys.columns c
  inner join sys.objects o on
  c.object_id=o.object_id order by o.name,c.column_id

http://stackoverflow.com/questions/2729126/how-to-find-column-names-for-all-tables-in-all-databases-in-sql-server