The Data Modeler supports SQL statements as listed in the following table:
Statement | Description |
|---|---|
CREATE TABLE | Creates a new table. |
CONSTRAINT...PRIMARY KEY() | Defines fields as Primary key of a table. |
ALTER TABLE... ADD PRIMARYKEY() | Defines fields as Primary key of a table. |
ALTER TABLE... ADD CONSTRAINT...PRIMARY KEY() | Defines fields as Primary key of a table. |
CREATE TABLE...AS SELECT... FROM... | Creates a new table with fields as selected from one table. |
Table 7: Supported SQL statements
The Data model supports exported DLL files from the databases below:
No | Name |
|---|---|
1 | SQLServer |
2 | Oracle |
3 | PostgreSQL |
Table 8: Supported Databases