Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

PropertyDescription
BlobBlockSizeBlob block size used to estimate the size of a table row in the capacity planning dialog. DATATYPE: Integer.
BlobOverheadBlob storage overhead used to estimate the size of a table row in the capacity planning dialog. DATATYPE: Integer.
CaseHandling CaseHandling used in the Model. Valid values are: 0 = PreserveCase, 1 = LowerCase, 2 = UpperCase. DATATYPE: Integer.
CaseShiftCaseShift setting used in the Model Options. Valid values are: 0 = PreserveCase, 1 = LowerCase, 2 = UpperCase. DATATYPE: Integer.
DatabasePlatformDatabase platform type of the model. DATATYPE: String.
DatatypeDatatype default in the Model. DATATYPE: String.
DatatypeNotNullableDdefault Datatype Nullability used in the Model. Valid values are: 0 = Nullable and 1 = NotNullable. DATATYPE: Integer.
DatatypeScaleDefault Datatype Scale used in the Model. DATATYPE: Integer.
DatatypeWidthDefault Datatype Width used in the Model. DATATYPE: Integer.
DimensionalDetermines whether a model is Dimensional (true) or Relational (false). DATATYPE: Boolean.
DisablePostSQLDisablePostSQL boolean used in the Model Options. If true, then PostSQL is not generated. DATATYPE: Boolean.
DisablePreSQLDisablePreSQL boolean used in the Model Options. If true, then PreSQL is not generated. DATATYPE: Boolean.
GenAlternateKeyGenerate Alternate Key in the Model. DATATYPE: Boolean.
GenForeignKeyGenerate Foreign Key in the Model. DATATYPE: Boolean.
GenInversionEntryGenerate Inversion Entry in the Model. DATATYPE: Boolean.
GenPKWithClusterGenerate the Primary Key with Cluster in Generate Physical Model. DATATYPE: Boolean.
GenPrimaryKeyGenerate Primary Key in the Model. DATATYPE: Boolean.
GUIDGUID of the model as assigned by ER/Studio. Each model has a unique GUID. DATATYPE: String.
IDID of the model as assigned by ER/Studio. Each model in a diagram has a unique ID. DATATYPE: Integer.
IndexOverheadIndex storage overhead used to estimate the size of an index in the capacity planning dialog. DATATYPE: Integer.

Determines whether the model is logical (true). DATATYPE: Boolean.

Generalized description of the database platform type of the model. DATATYPE: String.

Name of the model. DATATYPE: String.

Maximum Name Length used in the Model. Only Logical Models are changed by this property. DATATYPE: Integer.

NamePrefix used in Generating Physical Model. DATATYPE: String.

NameSynchronization scheme in the Model. Valid values are: 0 = Complete, 1 = Partial, 2 = None. DATATYPE: Integer.

ID of the NamingStandardsTemplate object bound to the model (if any). A user can bind a NamingStandardsTemplate to the model by assigning a particular NamingStandardsTemplateId to this property. DATATYPE: Integer.

Notation used in the Model. Valid values are: 0 = IDEF1X, 1 = IE, 2 = TRUE_IE, 3 = DASHED_IE. DATATYPE: Integer.

PostSQL string used in the Model Options. DATATYPE: String.

PreSQL string used in the Model Options. DATATYPE: String.

Default RoleName prefix used in the Model. DATATYPE: String.

Row storage overhead used to estimate the size of a table row in the capacity planning dialog. DATATYPE: Integer.

SpaceHandling used in the Model. Valid values are: 0 = PreserveSpaces, 1 = RemoveSpaces, 2 = UnderScoreSpaces. DATATYPE: Integer.

Statement delimiter of the model. DATATYPE: String.

Table storage overhead used to estimate the size of a table in the capacity planning dialog. DATATYPE: Integer.

...