dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Nov 21, 2019

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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 SELECT
Click the + next to the desired table in the Object Explorer
Drag the Columns folder to the query pane
Complete your query by including the FROM, the table name and conditions

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

Hannes du Preez
 
Thanks for your registration, follow us on our social networks to keep up-to-date