Creating Tables and Relationships

The primary entities in any database are its tables. Tables are composed of a structure and data. Server Explorer and the new SQL Server Object Explorer are the Visual Studio instruments used to define or edit the structure or data of any table within a connected database. In fact, using either Explorer, it is possible to create a new SQL Server database instance from scratch. Because the functionality between these Explorer windows is nearly identical, we won’t bother to illustrate every detail here within the context of both Explorers. The SQL Server Object Explorer (launched from the View menu, or by clicking the SQL Server Object Explorer button in the Server Explorer command bar) looks much more like the ...

Get Microsoft Visual Studio 2015 Unleashed, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.