Database dot dot TableName represent what in SQL Server? Interview Question

I think you are use to Database.dbo.Tablename, am I right, Have you ever use double dot after database name followed by table name? If not then what is mean?

Databasename..Tablename as you know database name followed by schema name, and then table name. So if we want to point default schema in database then we does not required schema name we can put double dot after database name it will point to default schema.
So if your default schema is dbo then below two statement are same.

Databasename.dbo.Tablename <=> Databasename..Tablename

Comments

Contact Form

Send