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’

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply