Chapter 8Understanding and designing tables
This chapter discusses a fundamental concept in relational databases: tables. Tables are the database objects that actually store the data in the database. Thoroughly understanding the concepts in this chapter is a requirement for designing and maintaining an effective database. We first discuss table design fundamentals, including data types, keys, and constraints. Next, we cover several specialized table types, such as temporal tables and graph tables. Then, we examine the specialized nature of storing binary large objects (BLOBs) in relational tables. Your understanding of table design would ...
Get SQL Server 2017 Administration Inside Out, First 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.
