SQL Server allows you to define cascading referential ... If a delete statement affects rows in a foreign key table, those values will be set to NULL when the primary key record is deleted.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

I'm adding a table and subclass table to my DB. (Subclass table = table where the primary key joins to the primary key of another table, to give extra row information to some subset of the rows.

This strategy helps you manage interrelated tables in your database. Click the Start button and launch the Microsoft SQL Server Management Studio. Click the Server Name menu and choose your server ...