What does ".." mean in "SELECT * FROM database..table"?

I understand than in the SQL statement that the part xxx

, say xxx.TableName

, refers to the schema of the data table. Typically, most tables are created as dbo.TableName

. When referencing a table in SQL code, the default schema can be omitted and you can simply refer to the table by the table name. Likewise, if you need to refer to a table in another database, you can refer to it with the following syntax Database.dbo.TableName

.

However, I just ran into a different user code that has Database..TableName

. What does it mean ..

? I can accept a reasonable answer, but I cannot find any specific documentation. (Google doesn't seem to work with double dot text.)

+3


source to share


1 answer


This is a short hand for using the default schema.

select x from steve..mark

is the logical equivalent as select x from steve.dbo.mark

if dbo is the standard schema



three part declaration convention for sql server

msdn FROM CLAUSE

+6


source







All Articles