Integrations (PTC products, 3rd party products and code) > Code integration (Ada, ARINC 653, C, C#, C++, IDL, Java, SQL and VB) > SQL code > Mapping information > Summary of mappings for SQL (SQL code)
  
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 button.
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.