Tables

Creating and Maintaining Databases

Creating and Maintaining Databases

Tables

Tables are database objects that contain all the data in a database. A table definition is a collection of columns. In tables, data is organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field within the record. For example, a table containing employee data for a company can contain a row for each employee and columns representing employee information such as employee number, name, address, job title, and home phone number.