What does the Double Period Mean in T-SQL Script?

When a double period is used, as in:
 
ExactMAXSampleDB..Part_Master
 
This means the schema is inferred to be the default schema of the current login.
 
In most cases this will be .dbo. So instead of having to provide it one could use the shortcut of the “..” or more correctly the default for that user which is more right due to the fact that the author of the script may not know which default is in use but may know the table and databases name that may well be standard as determined by the software app deployed.
 
Vince Stefanetti
Senior Consultant

                                              ID:12248195
 

Leave a Reply

Your email address will not be published. Required fields are marked *