SELECT *
Select
SELECT * to specify * for the
SELECT clause. This causes all the columns in each of the tables and views you selected in the
Tables/views list to be included in the result table.
Note:
When SELECT * is selected, the only other thing that can be included in the SELECT clause is the DISTINCT keyword.
Last modified date: 01/29/2015