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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access