VS has many database configuration settings that you can view via the Tools | Options
menu and selecting Database Tools, as shown in Figure 2. For example, one of the
|Figure -2 Database Tools options|
options found after clicking the arrow button to expand Database Tools and then selecting
Table And Database Designers is "Prevent saving changes that require table re-creation."
VS will not allow you to save a foreign key change to existing tables. However, by
unchecking "Prevent saving changes that require table re-creation," you'll be able to save
foreign key changes to an existing table.
As with so many other features of VS, there are literally dozens of database settings; most
are intuitive if you already understand SQL Server. Other options differ, depending on the
version of VS you have, and your Options screen might not look the same as Figure 2.
Now that you know how to create databases, tables, and stored procedures, you'll need
to know how to use your database from code.