Post reply

dbo prefix for tables only or for all?

  • April 21, 2006 at 9:33 am

    #152927

    For our development sql 2000 box our developers generally use the "dbo" prefix for table names. (e.g. dbo.Customers). But they do not use a prefix for views of stored procs (i.e. no dbo.spGetNames)

    I'm interested in your comments on the practice of using "dbo" as above and why, if they use it for tables, they wouldn't also use it for views and stored procs..

    TIA,

    Bill

  • April 21, 2006 at 9:44 am

    #633550

    I always post this link to chris hedgate's article on this topic..

    qualifying objects with owners







    **ASCII stupid question, get a stupid ANSI !!!**

  • April 21, 2006 at 10:41 am

    #633564

    Sushila,

    Thanks. I liked that article.

    By extension I guess the author would also qualify all stored proc and view name references.

     

    Bill

     

  • April 21, 2006 at 10:54 am

    #633567

    Bill..for that you'd have to read this discussion







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply