How can I get column names from a table in SQL Ser

Question

I would like to query the name of all columns of a table. I found how to do this in:

• Oracle
• MySQL
• PostgreSQL

But I need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Answer 1

SELECT c.Name 
FROM sys.columns c
JOIN sys.objects o ON o.object_id = c.object_id
WHERE o.object_id = OBJECT_ID('TABLE_NAME')
ORDER BY c.Name