Only selected columns from sp_columns

[StevenK]

I can achieve a list of field information (following a recent post and helpful replies) using the SQL syntax
EXEC sp_columns @table_name = 'Table1'
Suppose I only want a subset of this return data set ?
Suppose I only want a list of the 'COLUMN_NAME' entries - how can I do this through the means of a single SQL statement ? I want to try to avoid using temporary tables if I can (as I'm none too familiar with them and want to avoid learning curves).

Any help would be appreciated.
Thanks in advance
Steve

 

[Gauss]

Hello Steve!

You can use INFORMATION_SCHEMA :

SELECT Column_name FROM INFORMATION_SCHEMA.Columns
WHERE TABLE_NAME = 'table1'