Extract All

In the previous SQL code, the symbols column1Name, column2Name, and so on, are the names of the columns that you wish to extract from a given table. If you instead want to select the entire table, then instead of passing columns names, you can use an asterisk in a SELECT statement to represent all columns.

The attached statement will display all of a table's columns upon execution.

xxxxxxxxxx

SELECT * FROM tableName;