Home > Articles > Data > SQL

  • Print
  • + Share This
This chapter is from the book

Retrieving All Columns

In addition to being able to specify desired columns (one or more, as shown previously), you can also use SELECT statements to request all columns without having to list them individually. This is done using the asterisk (*) wildcard character in lieu of actual column names, as follows:

Input

SELECT *
FROM products;

Analysis

When you specify a wildcard (*), all the columns in the table are returned. The columns are in the order in which the columns appear in the table definition. However, you cannot rely on this because changes to table schemas (adding and removing columns, for example) could cause ordering changes.

  • + Share This
  • 🔖 Save To Your Account