When connected to a database, you can use the IDE to create tables in a database. You create a table in a connected database by right-clicking the Tables node in the Runtime window and choosing Create Table.
You can also grab and save a table definition which you can then use to recreate the table.
This name must follow conventions for table names in your database. Case is usually insignificant and you must not use spaces.
The dialog box defaults to the name by which you are connected.
Specify the column type (required) and column size. Column size is optional for some data types.
When you click Save, a database snapshot of the selected table is saved in the selected location. You can use the snapshot to re-create the table in the current database or in a different database.
To re-create a table from a table definition:
To recreate a table in a different database:
You can save the structure of a table from one database and recreate the table in a different database, even if the two databases have a different SQL syntax. You can thus create database-independent schemas. For example, you can develop a complete application with a database from one vendor and then for deployment, you can transfer the table structures to a different database by a different vendor. You do not need to edit the SQL.