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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.