devxlogo

Selecting All Columns, Separated with Commas

Selecting All Columns, Separated with Commas

Sometimes you want to select all the columns, without using the *. Specifying column names speeds up your query. The problem comes in with large tables or tables with difficult column names.

Solution:

Type SELECTClick the + next to the desired table in the Object ExplorerDrag the Columns folder to the query paneComplete your query by including the FROM, the table name and conditions

This gives you a nicely comma-separated list of column names.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist