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.
|
Create table |
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.
|
Edit 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. |
|
Drop table |
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. |
