I am looking at a new database schema developed by an external vendor. There are two databases:
Database1
Database2
They have sent me an SQL statement that joins tables between the two databases. There are places where they have used a double dot notation. I have never seen this before. Please see the SQL statement below (this is not the statement they sent me):
select * from database2..Person
The statement above is run from database1. Why does it have two dots? If I remove one of the dots then the query does not run.
I have done some Googling and came across this: http://www.sqlservercentral.com/Forums/Topic585446-338-1.aspx. This suggests it is referring to the schema. However:
- The schema is empty in the sql statement i.e. there is no text in between the two dots.
- The Person table is part of the dbo schema in database2.