O'Reilly logo

Microsoft Visual Studio 2015 Unleashed, Third Edition by Mike Snell, Lars Powers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Changing the Database

With a fully populated database project, you can now make any desired changes by opening any of the generated .sql files and editing the file. This works the same way that object editing works using the Server Explorer or the SQL Server Object Explorer: you can edit the raw SQL commands using the SQL editor or, if you opened a table’s .sql file, for instance, you can edit the table definition by using the designer or the SQL editor.

You can control a number of database and server options via the database project. You can access all these via the Project Properties dialog. These would rarely need to be changed by a developer (they are more likely to be within the database administrator’s scope of work), but let’s briefly ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required