AverageRowSize

Oracle 10g and later only. Read-only AverageRowSize property of the table.

 ClusterByColumns

Google BigQuery, Hive, and Snowflake only. Holds the comma-separated list of Clustered By columns. DATATYPE: String.

 Compress

Compress property of the table. DATATYPE: Boolean.

 CompressExpression

Oracle 9 and later only. Holds the table compress expression for the table. DATATYPE: String.

 DatabaseLocation

Database location of the entity. The input string cannot include dots or they are removed. DATATYPE: String.

 DB2Auditing

Table Storage Auditing option. Valid strings are NONE, CHANGES, and ALL. DATATYPE: String.

 DB2DataCaptureChg

Table Storage Log Data Changes value. DATATYPE: Boolean.

 DB2EditProc

Table Storage Edit Proc value. DATATYPE: String.

 DB2Encoding

Table Storage Encoding option. Valid strings are ASCII, EBCDIC, and NONE. DATATYPE: String.

 DB2InDatabase

Indicates whether the Table Storage is In Database. DATATYPE: Boolean.

 DB2OSVolatile

DB2 OS/390 V8 and later only. Indicates whether a table is volatile. DATATYPE: Boolean.

 DB2RestrictOnDrop

Table Storage Restrict On Drop value. DATATYPE: Boolean.

 DB2ValidProc

Table Storage Valid Proc value. DATATYPE: String.

 Definition

Definition of the entity. DATATYPE: String.

 DimensionTableType

Dimension Table Type. Valid strings are FIXED, TYPE1, TYPE2 or TYPE3. DATATYPE: String.

 DimModelTableType

Dimensional Model Table Type. Valid strings are DIMENSION, FACT, SNOWFLAKE or UNDEFINED. DATATYPE: String.

 DimModelTableTypeOverride

Sets the Dimensional Model Table Type Override on or off. Valid values are true or false. DATATYPE: Boolean.

 DoNotGenerate

If true, the Table is not generated in the DDL. DATATYPE: Boolean.

 EntityName

Name of the entity in the logical model. DATATYPE: String.

 FreeListGroups

FreeListGroups of the entity storage. DATATYPE: Integer.

 FreeLists

FreeLists of the entity storage. DATATYPE: Integer.

 FreezeName

True if this entity is not affected by naming standards name updates. DATATYPE: Boolean.

 GenPostSQL

Generate PostSQL option of the entity. DATATYPE: Boolean.

 GenPreSQL

Generate PreSQL option of the entity. DATATYPE: Boolean.

 GoogleBigqueryExpirationTimestamp

Date and time a Google BigQuery table is deleted along with all of the data contained within that table. DATATYPE: String.

 GoogleBigqueryKmsKeyName

Name of the key used to encrypt your encryption keys as part of the Google BigQuery Cloud Key Management Service (KMS). DATATYPE: String.

 GoogleBigqueryLabels

Name of a Google BigQuery label that you can apply to your resources, such as your datasets, tables, and views. DATATYPE: String.

 GoogleBigqueryPartitionExpirationTimestamp

Date and time Google BigQuery partitions in a table are deleted along with all of the data contained within each partition. This expiration is calculated independently for each partition based on partition time. DATATYPE: Integer.

 GoogleBigqueryPartitionBy

Time period by which Google BigQuery tables are partitioned. DATATYPE: String.

 GoogleBigqueryPartitionFilter

Y equals Boolean True if all queries for this table require a partition filter. DATATYPE: String.

 GoogleBigqueryPartitionType

Type of partitioning used to partition Google BigQuery tables. DATATYPE: String.

 GoogleBigqueryRangeFields

Range used to partition Google BigQuery tables. DATATYPE: String.

 GreenplumDistributionColumns

Greenplum only. GreenplumDistributionColumns property of the table. DATATYPE: String.

 GreenplumDistributionRandom

Greenplum only. GreenplumDistributionRandom property of the table. DATATYPE: Boolean.

 GrowthPeriod

Physical models only. Period the growth rate is based on. Valid strings are Day, Week, Month, Quarter, or Year. DATATYPE: String.

 GrowthRate

Physical models only. Determines how fast a table grows. DATATYPE: Integer.

 GrowthType

Physical models only. Type on which the growth rate is based. Valid strings are Percent or Rows. DATATYPE: String.

 GUID

GUID of the entity as assigned by ER/Studio. Each entity has a unique GUID. DATATYPE: String.

 HiRDBFix

Fix option of the entity storage. DATATYPE: Boolean.

 HiRDBRowLock

Row Lock option of the entity storage. DATATYPE: Boolean.

 HiRDBStorageIn

Storage In option of the entity storage. DATATYPE: Boolean.

 HiveAsSelect

Hive only. Holds AsSelect value for the table. DATATYPE: String.

 HiveClusteredByColumns

Hive only. Holds the comma-separated list of Clustered By columns. DATATYPE: String.

 HiveExternalTable

Hive only. External property of the table. If true, the table is created externally: CREATE EXTERNAL TABLE ... DATATYPE: Boolean.

 HiveLocation

Hive only. Determines where the table is stored in the HDFS. DATATYPE: String.

 HiveNumBuckets

Hive only. Determines the NUM_BUCKETS value for the table. DATATYPE: Integer.

 HiveRowFormatCollections

Hive only. Corresponds to COLLECTION ITEMS TERMINATED BY of the ROW FORMAT clause in the create table statement. It requires a true HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatDelimited

Hive only. Pertains to the RowFormat of the table. If true, the table is created with ROW FORMAT DELIMITED. You cannot set to true if a RowFormat SerDe is specified via HiveStoredBySerDeHandler. DATATYPE: Boolean.

 HiveRowFormatEscapedBy

Hive only. Corresponds to ESCAPED BY part of the FIELDS TERMINATED BY clause in the create table statement. It requires a set HiveRowFormatFields. DATATYPE: String.

 HiveRowFormatFields

Hive only. Corresponds to FIELDS TERMINATED BY of the ROW FORMAT clause in the create table statement. It requires a true HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatLines

Hive only. Corresponds to LINES TERMINATED BY of the ROW FORMAT clause in the create table statement. It requires a true HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatMapKeys

Hive only. Corresponds to MAP KEYS TERMINATED BY of the ROW FORMAT clause in the create table statement. It requires a true HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatNullDefinedBy

Hive only. Corresponds to NULL DEFINED AS of the ROW FORMAT clause in the create table statement. It requires a true HiveRowFormatDelimited and is available on DBServers beginning with Hive 0.13. DATATYPE: String.

 HiveRowFormatSerDeHandler

Hive only. Name of the SerDe handler for ROW FORMAT. It requires a false HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatSerDeProperties

Hive only. Holds the comma-separated properties for ROW FORMAT SerDe. It requires a set HiveRowFormatSerDeHandler. DATATYPE: String.

 HiveSkewedByColumns

Hive only. Holds the comma-separated list of Skewed By columns. DATATYPE: String.

 HiveSkewedByValues

Hive only. Holds the Skewed On Values for the table. DATATYPE: String.

 HiveSortedByColumns

Hive only. Holds the comma-separated list of Sorted By columns. DATATYPE: String.

 HiveStoredAs

Hive only. Is file format in the STORED AS clause. Valid strings are BINARYFILE, ORC, RCFILE, SEQUENCEFILE, TEXTFILE. Output also includes InputOutput Handler clause. HiveStoredBySerDeHandler must be empty. DATATYPE: String.

 HiveStoredAsByNumber

Hive only. Same as HiveStoredAs, but enumerates the file format as follows: 0 = not set, 1 = BINARYFILE, 2 = INPUT FORMAT OUTPUT FORMAT, 3 = ORC, 4 = RCFILE, 5 = SEQUENCEFILE, 6 = TEXTFILE. 2 is output only. DATATYPE: Integer.

 HiveStoredAsInputHandler

Hive only. Read only. INPUTFORMAT handler name of the STORED AS clause. Of the INPUTFORMAT handler.class.name string it returns the handler.class.name part. HiveStoredBySerDeHandler must be empty. DATATYPE: String.

 HiveStoredAsOutputHandler

Hive only. Read only. OUTPUTFORMAT handler name of the STORED AS clause. Of the OUTPUTFORMAT handler.class.name string it returns the handler.class.name part. HiveStoredBySerDeHandler must be empty. DATATYPE: String.

 HiveStoredBySerDeHandler

Hive only. Name of the SerDe handler that appears in the STORED BY clause of the Create Table statement. It requires an empty HiveStoredAs. DATATYPE: String.

 HiveStoredBySerDeProperties

Hive only. Holds the comma-separated properties for STORED BY SerDe. It requires a set HiveStoredBySerDeHandler. DATATYPE: String.

 HiveTblProperties

Hive only. Holds the TblProperties value for the table. DATATYPE: String.

 ID

ID of the entity. Assigned by ER/Studio. Each entity in a diagram has a unique ID. DATATYPE: Integer.

 IndexTablespace

Specifies the Tablespace in which to create the Index for this table. DATATYPE: String.

 InformixLockMode

Informix Online and Informix 9.x and later only. InformixLockMode property of the table. Possible values include 0 = PAGE and 1 = ROW. DATATYPE: Integer. 

 InitialExtent

Initial extent of the entity storage. DATATYPE: Integer.

 InitTransactions

Initial Transactions of the entity storage. DATATYPE: Integer.

 InterModelID

InterModelID of the object as assigned by ER/Studio. DATATYPE: Integer.

 IsStatic

Physical models only. Determines whether a table is a static table or will grow. DATATYPE: Boolean.

 LastSourced

Applies to DataLineage and displays when the data was last sourced only if the parent model is physical and is enabled for data movement. DATATYPE: String.

 LogForReplication

Specifies that the table's data are physically replicated on each partition on which the table is defined. DATATYPE: Boolean.

 LogOrPhysOnly

Controls the logical/physical only Entity Property. DATATYPE: Boolean.

 LongTablespace

Identifies the Tablespace in which the values of any long columns are stored. DATATYPE: String.

 MaxExtents

MaxExtents of the entity storage. Parameter can be positive integer as string or UNLIMITED. DATATYPE: String.

 MaximumRows

Physical models only. Maximum number of rows a table can hold. DATATYPE: Integer.

 MaxTransactions

MaxTransactions of the entity storage. DATATYPE: Integer.

 MinExtents

MinExtents of the entity storage. DATATYPE: Integer.

 MySQLTableType

Type of the table for MySQL model. Valid strings are MYISAM and INNODB. DATATYPE: String.

 NamingStandardsTemplateId

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

 NetezzaDistributionColumns

Netezza 4.6, 5.0 and later only. NetezzaDistributionColumns property of the table. DATATYPE: String.

 NetezzaDistributionRandom

Netezza 4.6, 5.0 and later only. NetezzaDistributionRandom property of the table. DATATYPE: Boolean.

 NetezzaOrganizationColumns

Netezza 6.0 and later only. Organization Key property of the table and contains up to four comma-separated columns. DATATYPE: String.

 NextExtent

Next extent of the entity storage. DATATYPE: Integer.

 NoLogging

Determines whether there is no logging (true) or logging (false) in the entity storage. DATATYPE: Boolean.

 Note

Note of the entity. DATATYPE: String.

 OracleAccessDriver

Sets/unsets the Oracle External Table Access Driver property. It can be set only if the OracleExternalTables property is TRUE.

 OracleAccessParameters

Sets/unsets the Oracle External Table Access Parameters property. It can be set only if the OracleExternalTables property is TRUE.

 OracleBufferPool

BufferPool of the entity storage. Valid strings are KEEP, RECYCLE, DEFAULT, and NONE. DATATYPE: String.

 OracleCache

Cache property of the entity storage. Must be heap organized. True for Cache on, false for Cache off. DATATYPE: Boolean.

 OracleDefaultDirectory

Sets/unsets the Oracle External Table Default Directory property. It can be set only if the OracleExternalTables property is TRUE.

 OracleExternalTables

Sets/unsets the Oracle External Table property.

 OracleExtLocation

Sets/unsets the Oracle External Table Location property. It can be set only if the OracleExternalTables property is TRUE.

 OracleDegrees

Degrees property of the entity storage. Degrees is only valid if parallel is true. DATATYPE: String.

 OracleIndex

Index property of the entity storage. It is true if index organized, false if heap organized. DATATYPE: Boolean.

 OracleInstances

Indexes property of the entity storage. Instances is only valid if parallel is true. DATATYPE: String.

 OracleParallel

Parallel option of the entity storage. DATATYPE: Boolean.

 OracleRowMovement

Oracle 9 and later only. OracleRowMovement property of the table. Not supported for non-partitioned index-organized tables. DATATYPE: Boolean.

 Owner

Owner of the entity. DATATYPE: String.

 PctFree

Percent free of the entity storage. DATATYPE: Integer.

 PctIncrease

Percent increase of the entity storage. DATATYPE: Integer.

 PctUsed

Percent used by the entity storage. DATATYPE: Integer.

 Persistence

Snowflake only. Holds the persistence type for a Snowflake table. Possible values returned are TRANSIENT, VOLATILE, GLOBAL, LOCAL, TEMPORARY, and PERMANENT.

 PostSQL

PostSQL of the entity. DATATYPE: String.

 PreSQL

PreSQL of the entity. DATATYPE: String.

 RowCount

Physical models only. Current number of rows in a table. DATATYPE: Integer.

 SourcingFrequency

DataLineage and applies only if the parent model is physical and is enabled for data movement. This property tells how often the data is sourced. DATATYPE: String.

 StorageLocation

Storage location of the entity. DATATYPE: String.

 SybaseIdentityGap

Identity Gap option of the entity storage. It must be a positive integer (in kilobytes). DATATYPE: Integer.

 SybaseLockingScheme

Locking Scheme option of the entity storage. The possible values are ALLPAGES, DATAPAGES or DATAROWS. DATATYPE: String.

 SybaseMaxRowsPerPage

Max Rows Per Page option of the Sybase table storage. DATATYPE: Integer.

 SybasePrefetchStrategyOn

Prefetch Strategy option of the entity storage. If it is true then the prefetch strategy is on, if it is false then it is off. DATATYPE: Boolean.

 SybaseReplacementStrategyMRU

Replacement Strategy option of the entity storage. If it is true then the MRU replacement strategy is use, if it is false then LRU is used. DATATYPE: Boolean.

 SybaseReservePageGap

Reserve Page Gap option of the entity storage. It must be a positive integer (in kilobytes). DATATYPE: Integer.

 SystemName

System name of the AS400 table. DATATYPE: String.

 TableDDL

TableDDL of the entity. DATATYPE: String.

 TableName

Name of the table in a physical model. DATATYPE: String.

 TeradataAfterJournal

After Journal option of the entity storage. The possible values are – --, NO, DUAL, LOCAL, NOT LOCAL or the empty string (meaning nothing has been specified). DATATYPE: String.

 TeradataBeforeJournal

Before Journal option of the entity storage. The possible values are – --, NO, DUAL or the empty string (meaning nothing has been specified). DATATYPE: String.

 TeradataChecksum

Teradata 12 and later only. TeradataChecksum property of the table. Possible values are Default, All, High, Medium, Low, None, or empty (no DDL output). DATATYPE: String. 

 TeradataDatablockSize

Datablock Size option of the entity storage. It can be a positive integer (in kilobytes) or the string MINIMUM or MAXIMUM. DATATYPE: Integer or String.

 TeradataDuplicateRowControl

DuplicateRowControl option of the entity storage. The possible values are SET, MULTISET or the empty string (meaning nothing is specified). DATATYPE: String.

 TeradataFallback

Fallback protection option of the entity storage. If it is true then Fallback protection is used for the table. DATATYPE: Boolean.

 TeradataJournalName

Journal Name option of the entity storage. If the entity has a Journal Table, then the name of the table is stored here. DATATYPE: String.

 TextImageFileGroup

Specifies the table space in which the text/image columns are stored for the table. DATATYPE: String.

 TextLabel

Text label of the AS400 table. DATATYPE: String.