Appendix
Related information
SQL Statement
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
Database list
The Data model supports exported DLL files from the databases below:
| No | Name |
|---|---|
| 1 | SQLServer |
| 2 | Oracle |
| 3 | PostgreSQL |
Table 8: Supported Databases