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.
    1. (Optional) Change the Domain Name to be different from the DDL.
    2. Select the Vendor of the DDL and then paste the DDL.
    3. 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: