Table mapping for SQL (SQL code)

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 > Table mapping for SQL (SQL code)

For each Table, ACS generates a create table instruction in the creation file, and a drop table instruction in the drop file.

The name of the generated Table is the mangled name of the Modeler Table. By default, the SQL_Mangle.ini file prefixes the generated Table name with the name of its parent item. For more information, see Setting up name conversions - optional (SQL code).

Examples

Package1 owns Table1.

If you generate Table1 using the SQL Server 2012 ACS Code Generator DLL, the creation file includes the following text.

CREATE TABLE Package1Table1(
);

If you generate Table1 using the SQL Server 2012 ACS Code Generator DLL, the drop file includes the following text.

DROP TABLE Package1Table1;