Tables
Relational databases store all their data in tables. A table is a data structure consisting of an unordered set of horizontal rows, each containing the same number of vertical columns. The intersection of an individual row and column is a field that contains a specific piece of information. Much of the power of relational databases comes from defining the relations among the tables.
To create a new table:
- Select the Database | New Object menu item.
- Select Table in the New Object window.
- Edit table properties and fields on the appropriate tabs of the New Table window.
Hint: To create new table you can also right-click the Tables node of the explorer tree and select the New Table... item from the popup menu.
To create a new table with the same properties as one of the existing tables has:
- Select the Database | Duplicate Object menu item.
- Follow the instructions of the Duplicate Object Wizard.
The Duplicate Object window allows you to select the database to create the new table in and to edit the result SQL statement for creating the table.
To edit the existing table (manage its fields, indices, data, etc):
- Select the table for editing in the explorer tree (type the first letters of the table name for quick search).
- Right-click and select the Edit Table <Table_Name> item in the popup menu or simply double-click the table.
- Edit table subobjects and data on the appropriate tabs of the Table Editor.
To change the name of the table:
- Select the table for editing in the explorer tree.
- Right-click and select the Rename Table <Table_Name> item from the popup menu.
- Edit table name in the dialog window.
To drop a table:
- Select the table for editing in the explorer tree.
- Right-click and select the Drop Table <Table_Name> item from the popup menu.
- Confirm dropping in the dialog window.
