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 2017 ACS Code Generator DLL, the creation file includes the following text.
CREATE TABLE Package1Table1(
);
);
If you generate Table1 using the SQL Server 2017 ACS Code Generator DLL, the drop file includes the following text.
DROP TABLE Package1Table1;