locked
DB owner RRS feed

  • Question

  • What does meant by dbo. prefix with table, procedures? How it affect perfomence if prefix is not used with objectes  in queries? how does it related to db_owner database role?

    A detailed answer pls.
    Monday, July 21, 2008 5:31 AM

Answers

  • 'dbo' is the default schema. If an object does not belong to any schema, it belongs to the 'dbo' schema.

    If you create a table for example without a schema, it is automatically assinged to the 'dbo' schema.

    It is helpful to use the 'dbo' schema performance wise, although the gain cannot be estimated.

    For UDF referencing, it is required.

    'dbo' schema is in the db_owner role.

    Check out the following script:

    Code Snippet

    use

    AdventureWorks;

    select

    * from sys.schemas

    exec

    sp_helprolemember db_owner



    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012


    • Edited by Kalman Toth Sunday, October 7, 2012 5:43 AM
    Monday, July 21, 2008 6:35 AM