Q: Where should I modify in a erwin model so that erwin will generate a CREATE TABLE statement from SET to MULTISET in a Teradata Physical Model?
A: Here are steps:
1. Please go to Table Properties and select "General" Tab
2. Go to "Row Control" field and select drop down arrow to change "SET" to "MULTISET"
3. Now you will be able to get Create Table statement as below:
CREATE MULTISET TABLE EMPLOYEES
EMPLOYEE_ID NUMBER(6) NOT NULL
FIRST_NAME VARCHAR(20) NULL
LAST_NAME VARCHAR(25) NOT NULL
CONSTRAINT EMP_SALARY_MIN CHECK ( salary > 0 )