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