Get column names of a table/view

SELECT [name] AS [Column Name]
FROM syscolumns 

WHERE id = (SELECT id FROM sysobjects WHERE type = 'U' AND [Name] = 'Your table name')

SELECT [name] AS [Column Name]
FROM syscolumns  

WHERE id = (SELECT id FROM sysobjects WHERE type = 'V' AND [Name] = 'Your view name')