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’
Articles that you might like:
Dealing with the column names that looks like SQL…
SQL Server 101 - Check if a column exists in a table- SQL Server 101 - How to add a column with a default…
How to check if the table exists in a database in…
SQL Server 101 - Return the Current DateTime- Other ways of specifying the alias name for a column…
How to reset the value of identity Column in SQL Server ?
SQL Server 101 - Search tables for a specific column name