sql-serversql-server-2008

How can I add a new schema to SQL Server 2008?

How do you add a new schema to a database?

I am creating a new table and would like to select my own schema from the properties list, but I don't know how to create it. I am using SQL Server Management Studio (SSMS) 2008.

Solution

  • Use the CREATE SCHEMA syntax or, in SSMS, drill down through Databases -> YourDatabaseName -> Security -> Schemas. Right-click on the Schemas folder and select "New Schema..."