How to return the column names from a table in SQL Server ?

You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure.

How to return the column names from a table in SQL Server ?

Use AdventureWorks2014
GO
exec sp_columns ‘Employee’

Leave a Reply

Your email address will not be published. Required fields are marked *