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 [email protected]_NAME