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

xnl28 gravatar image

895 56 60 62

(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.][2]

[2]: /upfiles/InsideSchemaView.png
more ▼

answered Mar 02, 2011 at 07:49 AM

Kevin Feasel gravatar image

Kevin Feasel
6.1k 3 5 11

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 6548 times

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