Edge tables

Relationships in SQL Server 2017 are represented with edge tables. To create an edge table, use the extended CREATE TABLE statement. Unlike node tables, an edge table can be created without a single property. In this example, you will create the dbo.Follows edge table, which should represent who is followed by whom from the set of users created in the previous section. Assume that the users follow the other users according to the following table:

User

Follows

@MilosSQL

@DejanSarka, @sql_williamd, @tomaz_tsql, @WienerSportklub

@DejanSarka

@MilosSQL, @sql_williamd, @tomaz_tsql, @nkolimpija

@sql_williamd

@DejanSarka, @tomaz_tsql

@tomaz_tsql

@MilosSQL, @DejanSarka, @sql_williamd

@WienerSportklub

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

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