System tables that manage storage

Two system tables in the master database and two more in each user database 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

Image shows the system tables that manage storage: sysusages and sysdevices in the master database, and syssegments, sysindexes, and syspartitions in the user databases.