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

For each Index, ACS generates a create index instruction in the creation file when using the SQL 2012 or Oracle 10g ACS Code Generator DLLs. Indexes are ignored when using the SQL 2003 ACS Code Generator DLL.

If the Index is not unique, a create index instruction is generated.

If the Index is unique, a create unique index instruction is generated.

The following examples are provided:

• Index that is not unique

• Index that is unique

Index that is not unique

Package1 owns Table1. Table1 owns Column1 and Index1. Index1 uses Column1 and is not unique.

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

CREATE INDEX Index1 ON Package1Table1(
Column1
);

Index that is unique

Package1 owns Table1. Table1 owns Column1 and Index1. Index1 uses Column1 and is unique.

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

CREATE UNIQUE INDEX Index1 ON Package1Table1(
Column1
);