Column mapping for SQL (SQL code)
For each Column, ACS generates a column definition in the create table instruction created for the owning Table.
If the Column's Can Be Null property is selected, it is generated as NULL.
If the Column's Can Be Null property is not selected, it is generated as NOT NULL. Note that in SQL Oracle 10g, NOT NULL is defined by the absence of NULL.
If the Column's Unique property is selected, the column is generated as unique through a unique instruction.
If the Column's Prime property is selected, it is generated as part of the primary key through a primary key instruction.
The name of the generated column is the mangled name of the Modeler Column. For more information, see
Setting up name conversions - optional (SQL code).
 |
The following examples are provided:
• Column that cannot be null
• Column that can be null
• Column that is unique
• Column that is the primary key
|
Column that cannot be null
Package 1 owns Table1. Table1 owns Column1, which cannot be null.
If you generate Table1 using the SQL Server 2012 ACS Code Generator DLL, the creation file includes the following text.
CREATE TABLE Package1Table1(
Column1 int NOT NULL
);
Column1 int NOT NULL
);
Column that can be null
Package 1 owns Table1. Table1 owns Column1, which can be null.
If you generate Table1 using the SQL Server 2012 ACS Code Generator DLL, the creation file includes the following text.
CREATE TABLE Package1Table1 (
Column1 int NULL
);
Column1 int NULL
);
Column that is unique
Package1 owns Table1. Table1 owns Column1, which is unique.
If you generate Table1 using the SQL Server 2012 ACS Code Generator DLL, the creation file includes the following text.
CREATE TABLE Package1Table1 (
Column1 int NOT NULL UNIQUE
);
Column1 int NOT NULL UNIQUE
);
Column that is the primary key
Package 1 owns Table1. Table1 owns Column1, which is a prime key.
If you generate Table1 using the SQL Server 2012 ACS Code Generator DLL, the creation file includes the following text.
CREATE TABLE Package1Table1 (
Column1 int NOT NULL PRIMARY KEY
);
Column1 int NOT NULL PRIMARY KEY
);