Search code examples
sqlsql-serversql-server-2008t-sql

How can I get column names from a table in SQL Server?

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

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

Solution

  • You can obtain this information and much, much more by querying the Information Schema views.

    This sample query: 

    SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

    Can be made over all these DB objects: