Table Editor

The Table Editor enables you to create, modify, and save tables in a database.

Database tables contain the following elements:

• Columns. A table contains rows of related columns. A column represents one feature, characteristic, or fact about the table subject. Each row contains one instance of the table subject.
• Data Types. A data type describes how data is stored in a column. For example, the CHARACTER data type stores a value as a string of letters, numbers, and symbols.
• Primary Keys. Every table in a database should contain a primary key. A primary key is a column or group of columns that uniquely identifies a row in the table.
• Foreign Keys. A foreign key is a column or group of columns in one table (foreign key table) that is dependent on data in another table (primary key table). When you create a foreign key, you define the relationship between the primary key table and the foreign key table.
• Indexes. An index is used to quickly locate a row in a table based on the value of a column or group of columns. Indexes can improve performance when locating rows based on specific criteria or when sorting returned data.

Using Table Editor, you can define column properties, foreign keys, constraints, indexes, and storage location for tables.