Post reply

Creating a table in Management Studio with a different schema

  • December 10, 2007 at 2:31 pm

    #179859

    I am trying to create tables in Management Studio using a different schema from the dbo default. I created the new schema in my DB and set my users default schema to this new one. When I go to create a new table, it is defaulting to dbo and I don't see how I can change this, other than just using SQL statements. How can I do this?

  • December 10, 2007 at 2:57 pm

    #758780

    You would have to default your schema to the new one. By default in SSMS, you create schemas in your own schema, which probably defaults to dbo.

    Use SQL statements to create the table or change the schema.

  • December 10, 2007 at 10:40 pm

    #758834

    Steve is right, you can set your default shema to user. For setting it default schema take help from link given below

    http://msdn2.microsoft.com/en-us/library/ms176060.aspx

  • December 11, 2007 at 6:02 am

    #758909

    But if you're using the GUI and you still need to change the schema, display the properties page from the table creation screen. You can change the schema there. Same thing when editing the table in the GUI.

    I'd still recommend you follow everyone elses advice and use TSQL.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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