Summary of mappings for SQL (SQL code)
This table provides a summary of how Modeler item types map to SQL code.
For more information about a mapping, click the associated link.
Modeler
SQL Code
Column definition in the create table instruction.
Used as scoping name for generated tables.
Create index instruction in the creation file.
Not generated.
Used as scoping name for generated tables.
Add foreign key instruction in the creation file. Drop foreign key instruction in the drop file.
Create table instruction in the creation file. Drop table instruction in the drop file.
Was this helpful?