7.8. Tables
A table is an unordered set of records, consisting of rows and columns. Each column has a defined data type, and each row represents an entry in the table. Figure 7.9 shows an example of a table with n rows and m columns. The sales_person column with a VARCHAR data type is the first column in the table, followed by the region column with a CHAR data type. The year column is the mth column in the table and has an INTEGER data type.
Figure 7.9. An example of a table
7.8.1. Table Classification
Tables in DB2 can be classified as illustrated in Figure 7.10. You will learn more about each of these tables in the next sections.
Figure 7.10. ...
Get Understanding DB2®: Learning Visually with Examples 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.
