You can create a table using the Create Table dialog box.
You can also recreate a table in one of two ways
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.
All other properties are optional.
To re-create a table and its structure using a database snapshot:
NOTE
You can recreate a table in a different database from the one from which
you saved the structure, even if the SQL syntax to create the second database
is different from the syntax of the first. You can thus create database-independent
schemas with the Database Explorer. For example, you can develop a complete
application with a Pointbase database. For deployment, you can transfer the
table structures to an Oracle database to create the Oracle database without
editing SQL.
See also | |
---|---|
Browsing Structures Enabling and Disabling Debug Mode to Monitor SQL Commands Adding a Database Column to a Table |