O'Reilly logo

SQL Server 2017 Administration Inside Out, First Edition by Randolph West, William Assaf, Sven Aelterman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required