Léonard Laiter Léonard Laiter - 1 year ago 95
SQL Question

What is tableName.* in SQL

I can't find the answer of this on the web(probably because google doesn't like special characters), what does a query of this form mean?

Select tableName.* FROM tableName


I would say it's like
Select * from tableName
but then it would make no sense to add the table name in
Select
statement?

Answer Source
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
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download