(Contents)(Previous)(Next)

Defining a Table Like Another Table (CREATE Table Like)

From a table list, select the Object / New menu function followed by the Table Like submenu item to display the dialog box shown below for entering table names. The Like Table text box contains the name of the table selected from the table list.

Once again, DOMAIN offers you the option of displaying a table list from which you can select the relevant table. To do so, click on the button to the right of the Like Table Name or Owner text box.

A selection list of all your tables appears. If the desired table is not one of your tables, you can use the Select command button to request a dialog box from which you can select any desired table list.

If you call the same Object / New / Table Like function from the object type list, the Like table contains no entries.

In a distributed configuration, the With Replication option allows you to specify whether or not the table is to be replicated (see the With Replication option of the CREATE TABLE statement).

Use the Create table temporary option to create a temporary table which is only kept for the session of the current user. When doing so, it is possible to set the option Ignore Rollback which has the effect that the table is not subject to transaction mechanism.

Click on the OK command button to create the table and close the dialog box.

Another method for defining a table like another table is to start from the definition of an existing table and create a new table as a copy. Use the Object / Copy function to transfer an existing table definition to the design mode and save it under a new name using the Object / Save function. Before saving, you can make any modifications that should be desired.


(Contents)(Previous)(Next)