SQL Server list columns in table

 

This is one method of getting a list of all the columns in a table on SQL Server

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=@TABLE_NAME