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

Follow these steps to create the SQL table under a different schema:

Step 1: Right-click on the Tables node and choose the New Table.

Step 2: Open the properties window (view -> Properties Window), with the help of table designer open.

Step 3: Now, you can change the schema that the table will be made in by choosing the schema in the properties window.