Post reply

DMO

  • May 15, 2007 at 4:26 am

    #92399

    I am new to SQL Server. I want to know what is a DMO. Whenever I create a new table it is named dmo.tablename. I want a table to be specific to a user I create.

    "Here is a test to find out whether your mission in life is complete. If you're alive, it isn't. "

    Richard Bach

  • May 17, 2007 at 11:35 pm

    #707306

    DMO is an obsolete object model that wraps SQL Server.  It has been replaced with SMO in 2005.

    but I think you are thinking of dbo, not DMO.  dbo (usually) in 2005 is the default schema that objects are created in.  In 2000, there are no schemas and dbo is a user.

    if you want to create a table in a differet schema (2005) or owned by a different user (2000) just specify it in the DDL thus:

    create table MySchema.MyTable (mycolumn int) --2005

    create table MyUser.MyTable (mycolumn int) --2000

    ---------------------------------------
    elsasoft.org

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

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