sql query to get only the column names of a table

1) sp_help products

2) select sc.* from sys.columns sc 

 inner join sys.objects so on so.object_id = sc.object_id 

 where so.name='products'

3) select * from information_schema.columns where table_name='products'

Here products is the table.

Hope this will answer your question. If it is useful then mark it as accept answer.

Try:

SELECT column_name  

FROM information_schema.columns 

WHERE table_name = 'whatever'