|Database Tour Documentation|
To create a table in open database, choose Table | New....
There will be three ways of creating table available:
1. Using a special tool
This way gives you an opportunity to create a table in step by step mode.
If no errors are found, then the specified table will be created and you will see it in the table list to the left of main window; otherwise, you may click Back button, correct erroneous field entries and try again. In the case of continuous error messages, you may go back to the first step, select the third way of creating the table (see 3.), and generate SQL text, correct it manually to avoid the error(s), and create the table by executing the SQL query.
The working with Fields table is very similar to working with database tables in Database Tour. Here are described the hot keys for several most important actions:
2. Using SQL
After selecting this option and clicking Next/Finish button, you will be moved to SQL Editor, in which CREATE TABLE template will be shown in it.
Another way of getting the same result is to go to SQL | Edit page, click Templates button right above the SQL editor, and select Create Table template from the dropdown list of SQL templates.
After that, just correct the table and field names in this SQL text and click Execute button. If no errors are found, then the specified table will be created and you will see it in the table list to the left of main window.
3. Using tool to produce SQL
This way will give you an opportunity to specify field names and table name for the new table, as you do in the first way (see above). But after clicking Finish button, the new table will not be created. Instead of this, you will be moved to SQL Editor, in which the SQL text will be generated according to the specified field array and table name. And you will need then to click Execute button by yourself to create the table.
If you have enough experience in SQL, you may check the generated SQL and correct it if you wish before executing the query; otherwise this will be a good way to learn SQL for creating tables.