Post reply

Can not create different schema table from the Database Diagrams other than dbo

  • August 24, 2012 at 2:01 pm

    #266662

    Hello:

    I tried to create a new table within the database duagram, and when I save it, it assumes 'dbo' schema.

    How can I assign a different schema once I create the table?. When I save it, it saves with dbo schema always.

    Help!!!!!!

  • August 24, 2012 at 2:42 pm

    #1529963

    interesting Pablo;

    If i drag add existing tables that belong to a different schema, no problem;

    creating them via the diagrams interface, you can't specify the schema, i agree.

    I think you'll have to create the tables outside of the diagrams and add them; maybe run two different windows so you can add them and then click add tables int he diagram.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 24, 2012 at 5:01 pm

    #1530001

    AFAIK you have the same problem if you try to create a table from the Object Explorer/using the Table Designer. The GUI just doesn't seem to support Schemas very well.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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