I have an existing Visual Studio 2010 database project. All the current objects are in the default schema dbo.I want to add a new schema to the database project and add objects into that schema. How do I do that?
asked Mar 02, 2011 at 07:21 AM in Default
Use the Schema View. First, if you don't have it already, go to View and select "Database Schema View."
Then, in your schema view, you can organize by schema (which is what I prefer, personally, and is circled in the image below). If you do that, you'll see a Schemas folder. Right-click on it and select "Add --> Schema." Create your schema name. In each schema, you will have folders for tables, views, etc. You can right-click the appropriate type and add a new table/view/stored procedure/function.
![Schema View. The circle indicates the toggle for displaying by schemas or tables.]: /upfiles/InsideSchemaView.png
answered Mar 02, 2011 at 07:49 AM