Blog » By Vishal Gajjar on Sql&Me

SQL Server – Four-part object names

Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion if objects with similar names exists in different schemas. Some features requires that two-part naming must be used such as creating a view WITH SCHEMABINDING.

However, you can also use a four-part name to refer objects. Four-part object reference format consists of:

<< Server.Database.Schema.Object >> 

Only object name is required to reference an object, (schema name when the object is not in user’s default schema) all else is optional.

For example, all statements below will work in SQL Server:

USE   msdb

 

/*    Four-part name */

SELECT Name FROM VGAJJAR2.msdb.dbo.backupset

 

/*    Server name omitted */

SELECT Name FROM msdb.dbo.backupset

 

/*    Server/database name omitted */

SELECT Name FROM dbo.backupset

 

/*    Server/database/schema name omitted,

      only default schema name can be omitted */

SELECT Name FROM backupset

 

 

/*    And this works too… */

SELECT Name FROM …backupset

SELECT Name FROM ..dbo.backupset

SELECT Name FROM .msdb.dbo.backupset

SELECT Name FROM .msdb..backupset

Hope This Helps!

Vishal

If you like this post, do like my Facebook Page -> SqlAndMe
EMail me your questions -> Vishal@SqlAndMe.com
Follow me on Twitter -> @SqlAndMe


Filed under: Catalog Views, SQLServer

  1. amoxil amoxil online
    accutane order accutane online
    cialis deutschland cialis 20mg

  2. http://comprar-cialis-generico.net/ cialis
    http://comprarviagragenerico-es.net/ viagra generico
    http://viagrakaufengenerika.net/ viagra

  3. http://comprar-cialis-generico.net/ cialis
    http://comprarviagragenerico-es.net/ viagra
    http://viagrakaufengenerika.net/ viagra bestellen rezeptfrei

  4. dmlf louboutin khni louboutin shoes pkld louboutin men ltac http://nowchristianonsale.com/

  5. order xanax cheap xanax prescription - buy xanax uk online

  6. I really like reading a post that can make men and women think.
    Also, thanks for allowing for me to comment!

  7. I really like reading a post that can make men and women think.

    Also, thanks for allowing for me to comment!

  8. [url=http://acquistareviagragenericoit.com/]viagra[/url] viagra

  9. [url=http://buykamagraonlineinstant.com/#10072]kamagra 50 mg[/url] - kamagra 50 mg , http://buykamagraonlineinstant.com/#4496 kamagra 50 mg

  10. What's up everyone, it's my first go to see at this web page, and post is actually fruitful in
    support of me, keep up posting these posts.

  11. What's up everyone, it's my first go to see at this web page,
    and post is actually fruitful in support of me, keep up posting these posts.

  12. I'm really inspired along with your writing abilities and also with the structure to your weblog. Is this a paid subject matter or did you customize it your self? Either way keep up the excellent high quality writing, it is rare to look a great blog like this one nowadays..

  13. I'm really inspired along with your writing abilities and also with the structure to your weblog. Is this a paid subject matter or did you customize it your self? Either way keep up the excellent high quality writing, it is rare to look a great blog like this one nowadays..

  14. Generally I do not learn post on blogs, however I wish to say that this
    write-up very compelled me to try and do so!
    Your writing style has been amazed me. Thank you,
    quite great article.

  15. Generally I do not learn post on blogs, however I wish to
    say that this write-up very compelled me to try and
    do so! Your writing style has been amazed me. Thank you, quite great article.

  16. ED治療薬のシアリスhttp://xn--ed-u41gn1j.net/cialis.html

  17. ED治療薬のシアリスhttp://xn--ed-u41gn1j.net/cialis.html

  18. ED治療薬のシアリスhttp://xn--ed-u41gn1j.net/cialis.html

  19. [url=http://www.michaelkorssale2013.com/]michael kors outlet[/url] dcgwhj michael kors bags nrczwg michael kors purses ikyjyc [url=http://www.northfaceoutlet2012.co.uk/]north face sale[/url] uomtqr north face jacket tqupte north face iznamj [url=http://www.billigwellensteynjacken.de/]wellensteyn[/url] ofgjav wellensteyn schneezauber qomihp wellensteyn xurkrn

  20. It is delightful
    generic viagra online http://bestgenericviagra.biz/ cialis advertising video
    , buy generic cialis. viagra cialis in india
    .

  21. viagra viagra commander
    generico viagra viagra comprar online
    viagra viagra ricetta medica
    preise viagra bestellen viagra

  22. Completely I share your opinion. Thought good, it agree with you.
    . http://cheap-viagra-generic.com/#2054 - cheap viagra. were found in this
    generic cheap viagra us licensed pharmacies
    .

  23. I join told all above. We can communicate on this theme. Here or in PM.
    . buy cheap viagra. ever seen in this
    viagra online cheap price
    .

  24. What touching words :)
    . viagra price online. n't seen any of this
    viagra price sale
    .

  25. Il est interessant :)
    acheter viagra pharmacie belgique
    http://www.everyoneweb.fr/acheter-viagra-sans-ordonnance-france/ acheter viagra au maroc
    , acheter viagra ligne belgique
    . acheter viagra en suisse
    . Malgre tout
    peut acheter viagra france sans ordonnance
    .

  26. Il est remarquable, il est une piece amusante
    acheter viagra ligne belgique
    http://www.everyoneweb.fr/Viagra-en-ligne-prix-France2/ comment acheter viagra suisse
    , acheter du viagra en france en ligne
    . acheter viagra quebec
    . Quelque chose ne sorte pas laisser
    acheter viagra en suisse
    .

  27. Excellente idee, je soutiens.
    acheter viagra pharmacie belgique
    . http://www.everyoneweb.fr/Acheter-viagra-enligneFrance/

  28. Incredible! This blog looks exactly like my old one!
    It's on a totally different subject but it has pretty much the same layout and design. Great choice of colors!

  29. Incredible! This blog looks exactly like my old one!

    It's on a totally different subject but it has pretty much the same layout and design. Great choice of colors!

  30. Il acceptez, le message utile
    acheter viagra france ligne
    . http://www.everyoneweb.fr/Acheter-viagra-enligneFrance/

  31. buy tramadol online tramadol hcl 50 mg tab side effects - buy tramadol online for cheap

  32. Hello to all, how is the whole thing, I think every one is getting
    more from this web page, and your views are pleasant designed for new users.

  33. Hello to all, how is the whole thing, I think every one is getting more
    from this web page, and your views are pleasant designed for new users.

Speak Your Mind

  • No HTML is allowed.