Description
The Import from DDL option can be used to import a data model as a single data definition language (DDL) or multiple into a Project. A Single Table DDL can be used to create a single Domain by pasting a single table DDL.
Note: A DDL File can be read to create multiple Domains within a Project. To learn more about this method, please view this help article.
In This Article
Sample 'User' DDL
create table `user` ( id int(10) not null auto_increment, external_id varchar(50) not null unique, first_name varchar(25) not null, last_name varchar(25) not null, middle_initial char(1), username varchar(100) not null, ssn varchar(15) not null, password varchar(255) not null, activation_date date, primary key (id));
How to create a single Domain from a DDL
- In the Projects Dashboard, navigate to the Domains Pane. The Domains Pane will not appear until a Project has been selected.
- Open the New Domain drop-down menu.
- Click on the Import from DDL option in the menu.
- Select the Import Single Domain from DDL option in the Create New domain from DDL dialog and click Next.
- In the New Domain from DDL dialog, enter all information about the DDL.
- (Optional) Change the Domain Name to be different from the DDL.
- Select the Vendor of the DDL and then paste the DDL.
- Click the Save button after this information has been added.
- The new Domain will be created automatically, and you will be redirected to the Domain Dashboard, as shown below:
- NOTE: The Import from DDL option does not support some keywords. Make sure to remove any of the keywords below before importing the DDL:
- DEFAULT 'N'::bpchar
- FOR SBCS DATA
- WITHOUT TIME ZONE
- ON UPDATE CURRENT_TIMESTAMP(N)
- GENERATED BY DEFAULT AS IDENTITY START WITH N
- FORMAT 'K' BETWEEN M AND N
Training Video
The following video can be viewed to learn more about creating a Domain from a DDL as well: