What is tableName.* in SQL

SELECT tableName.* 
FROM tableName

is exactly that same as

SELECT * 
FROM tableName

Where it is useful is in a JOIN, for example:

SELECT table1.*
FROM table1
JOIN table2 ON table1.ID = table2.ID

Leave a Comment