Chapter 7

Understand table features

A key aspect of relational databases is how data is stored in tables. It is important to understand both how tables should look to the user and how they are structured internally.

This chapter covers fundamentals including data types, keys, and constraints. It also covers special table types, including temporal tables and graph tables. At times, organizations choose to store binary large objects (BLOBs) within relational tables. This chapter covers the implications of storing this type of data within SQL Server, as well as ...

Get SQL Server 2022 Administration Inside Out 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.