O'Reilly logo

SQL: Visual QuickStart Guide by Chris Fehily

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

Tables, Columns, and Rows

First, a little terminology: If you’re already familiar with databases, you’ve heard alternative terms for the same concepts. Table 2.1 shows how interchangeable terms are related. Formal relational-model terms are in the first column, ANSI SQL standard and DBMS documentation terms are in the second column, and the third-column terms are holdovers from traditional (nonrelational) file processing. I use SQL terms in this book (even when I’m discussing the model).

Tables

From a user’s point of view, a database appears to be a collection of one or more tables (and nothing but tables). A table:

  • Is the database structure that holds data.

  • Contains data about a specific entity type. An entity type is a class of distinguishable ...

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