As a relational database management system, SQLWizard stores data in a collection of tables. A table is a named data object made up of columns and rows of data. The data in one or more columns can usually be used to uniquely identify the rows of a table. These identifying columns are known as the primary key columns. Tables can be related to each other based on the data in one or more columns of the related tables. Indexes can be built on the table to speed retrieval and enforce uniqueness among records.
Often a table is identified with a three-part naming convention, where the table name is preceded by the Location and AuthID. The three parts of the name are separated by periods. For example, the table name SYSTEM.SYSIBM.SYSTABLES identifies the SYSTABLES table as being in the SYSTEM location and owned by the SYSIBM AuthID.