sql query to get only the column names of a table

Question

Senthilkumar · Answer

There are various ways to get the schema of the sql server 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.

Sam Hobbs · Answer

A very similar question is bind combo box with the field names of a table?

Vulpes · Answer

Try: SELECT column_name FROM information_schema.columns WHERE table_name = 'whatever'