How do I create a SQL table under a different schema

Question

This is from SQL Server 2008  ssms  When I create a table  it creates under dbo   I would like to create it under a different schema  but when I use the  New Table  dialog  I can never find the field where to specify this

User · Accepted Answer

Right-click on the tables node and choose New Table    With the table designer open  open the properties window  view -  Properties Window   You can change the schema that the table will be made in by choosing a schema in the properties window

User · Answer

Hit F4 and you ll get what you are looking for

User · Answer

nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp   create a database schema in SQL Server 2008 1  Navigate to Security   Schemas 2  Right click on Schemas and select New Schema 3  Complete the details in the General tab for the new schema  Like  the schema name is  MySchema  and the schema owner is  Admin   4  Add users to the schema as required and set their permissions  5  Add any extended properties  via the Extended Properties tab  6  Click OK    nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  nbsp  Add a Table to the New Schema  MySchema  1  In Object Explorer  right click on the table name and select  Design   2  Changing database schema for a table in SQL Server Management Studio 3  From Design view  press F4 to display the Properties window  4  From the Properties window  change the schema to the desired schema  5  Close Design View by right clicking the tab and selecting  Close   6  Closing Design View 7  Click  OK  when prompted to save 8  Your table has now been transferred to the  MySchema  schema   Refresh the Object Browser view To confirm the changes Done

User · Answer

Shaun F s answer will not work if Schema doesn t exist in the DB  If anyone is looking for way to create schema then just execute following script to create schema   create schema  schema name  CREATE TABLE  schema name   table name          ON  PRIMARY    While adding new table  go to table design mode and press F4 to open property Window and select the schema from dropdown  Default is dbo   You can also change the schema of the current Table using Property window   Refer

User · Answer

The default schema for the user could be changed with the following query and avoids changing the property every time a table is to be created  USE  DBName   GO  ALTER USER  YourUserName  WITH DEFAULT SCHEMA    YourSchema   GO

User · Answer

Try running  CREATE TABLE  schemaname   tableName   GO   This assumes the schemaname exists in your database    Please use CREATE SCHEMA  schemaname  if you need to create a schema as well   EDIT  updated to note SQL Server 11 03 requiring this be the only statement in the batch

User · Answer

When I create a table using SSMS 2008  I see 3 panes    The column designer Column properties The table properties   In the table properties pane  there is a field  Schema which allows you to select the schema

[sql] How do I create a SQL table under a different schema?

Examples related to sql

Examples related to sql-server-2008

Examples related to ssms