Thursday, 12 May 2016

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
Visit Our New Site for HR Interview Questions Answers
Sponsored Ads


Post a Comment