Two system tables in the master database, sysusages and sysdevices, and three more in each user database (syssegments, sysindexes, and syspartitions) track the placement of databases, tables (including the transaction log table, syslogs), and indexes. The relationship between the tables is illustrated in Figure 6-1.
Figure 6-1: System tables that manage storage
