Get column name from one table

SELECT [name] AS [Column name]

FROM syscolumns

WHERE id = (SELECT id

FROM sysobjects

WHERE type = 'U'

AND [NAME] = 'product')