Search code examples
sql-serverssmsadventureworks

How to create table in another schema SSMS

I have created a table in Person schema in AdventureWorks2012 with sql query. But I don't know how to do this with SSMS wizard.

I did it this with the query. 

Create table [SchemaName].[Tablename]

But I couldn't it with SSMS Databases -> [AdventureWorks] -> [Tables] -> (right-click) Table

I gave Table name [Person].[Person2] but It created in dbo schema and table name was wrong.

Solution

  • When you are in the table designer, open the Properties window either from View menu and then Properties Window or just press F4)

    In that dialog, you can change various properties of the table, including the schema.