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.

Answer 1

Try running CREATE TABLE [schemaname].[tableName]

Answer 2

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

Answer 3

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.