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