Add schema to VS2010 database project

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?

more ▼

asked Mar 02, 2011 at 07:21 AM in Default

avatar image

905 60 64 68

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Use the Schema View. First, if you don't have it already, go to View and select "Database Schema View."

Display the 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.

more ▼

answered Mar 02, 2011 at 07:49 AM

avatar image

Kevin Feasel
6.2k 4 7 15

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 02, 2011 at 07:21 AM

Seen: 7900 times

Last Updated: Mar 02, 2011 at 07:21 AM

Copyright 2016 Redgate Software. Privacy Policy