Returns an object representing a collection of attributes in the entity.

 BoundAttachments

Get all the BoundAttachments of this Entity.

 BoundSecurityProperties

Get all the BoundSecurityProperties of this Entity.

 ChildRelationships

Returns an object representing a collection of child relationships for the entity.

 DataMovementRuleLinks

Get all the DataMovementRules bound to this Entity.

 DB2OS390TablePartitions

Returns the collection of DB2 OS/390 table partitions. Also manages the partition key.

 DB2UDBDimensions

Returns a collection of DB2 UDB v9.x dimensions.

 DB2UDBTableRangePartitions

Returns the collection of DB2 UDB v9.x table range partitions. Also manages the partition key.

 DeleteNamingStandardsTemplate

Unbind this Entity from the naming standards template by deleting the naming standards template ID from the entity.

 GetNamingStandardsTemplate

Returns the naming standards template bound to the entity or null, if none is bound to the entity.

 HiveStoredAsInputOutputHandlers

Use to set INPUTFORMAT and OUTPUTFORMAT handler class names for the STORED AS clause of the Create Table statement. Either strings must be empty or both strings must contain a handler name.

 Indexes

Returns an object representing a collection of indexes in the entity.

 ObjectPermissions

Returns the collection of Object Permissions for this object.

 OracleTablePartitions

Returns the collection of oracle table partitions. Also manages the partition key and subpartition key and table level subpartitions.

 ParentRelationships

Returns an object representing a collection of parent relationships for the entity.

 RepoCheckOutStatus

Get the Check Out status of this Entity object. DATATYPE: StringObjects.

 RepoVersionHistory

Get the Version History of this Entity from the Repository server. Return the data in the StringObjects collection. DATATYPE: StringObjects.

 TableCheckConstraints

Returns an object representing a collection of Table Level Check Constraints in the entity.

 Triggers

Returns an object representing a collection of triggers in the entity.

 UniversalMappings

Returns a collection of universal mappings applied to this object.

 UserComments

Returns a collection of user comments associated with the entity.

 UserDefinedMappings

Returns a collection of user defined mappings applied to this object.

 WhereUsedModelUsage

Returns a collection of matches in other models based on the results of a WhereUsed analysis on this object.

 WhereUsedSubmodelUsage

Returns a collection based on the results of a WhereUsed analysis of SubModels in the current model that contain this object.

 AverageRowSize

This is the readOracle 10g and later only. Read-only AverageRowSize property of the table. It applies only to Oracle 10 g and higher versions of Oracle platforms.

 ClusterByColumns

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

 Compress

This is the Compress property of the table. DATATYPE: Boolean.

 CompressExpression

This property holds Oracle 9 and later only. Holds the table compress expression for the table. It only applies to Oracle 9 and older versions. DATATYPE: String.

 DatabaseLocation

This is the Database location of the entity. The input string should not cannot include dots . Dots will be or they are removed. DATATYPE: String.

 DB2Auditing

This is the Table Storage Auditing option. The only valid Valid strings are NONE, CHANGES, and ALL. DATATYPE: String.

 DB2DataCaptureChg

This is the Table Storage Log Data Changes value. DATATYPE: Boolean.

 DB2EditProc

This is the Table Storage Edit Proc value. DATATYPE: String.

 DB2Encoding

This is the Table Storage Encoding option. Valid string values strings are only ASCII, EBCDIC, and NONE. DATATYPE: String.

 DB2InDatabase

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

 DB2OSVolatile

This specifies if a table is volatile and it applies only to DB2 OS/390 V8 or later versionsand later only. Indicates whether a table is volatile. DATATYPE: Boolean.

 DB2RestrictOnDrop

This is the Table Table Storage Restrict On Drop value. DATATYPE: Boolean.

 DB2ValidProc

This is the Table Storage Valid Proc value. DATATYPE: String.

 Definition

This is the definition Definition of the entity. DATATYPE: String.

 DimensionTableType

This is the Dimension Table Type. The possible values Valid strings are FIXED, TYPE1, TYPE2 or TYPE3. DATATYPE: String.

 DimModelTableType

This is the Dimensional Model Table Type. The possible values Valid strings are DIMENSION, FACT, SNOWFLAKE or UNDEFINED. DATATYPE: String.

 DimModelTableTypeOverride

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

 DoNotGenerate

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

 EntityName

This is the name Name of the entity in the logical model. DATATYPE: String.

 FreeListGroups

This is the FreeListGroups of the entity storage. DATATYPE: Integer.

 FreeLists

This is the FreeLists of the entity storage. DATATYPE: Integer.

 FreezeName

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

 GenPostSQL

This is the Generate PostSQL option of the entity. DATATYPE: Boolean.

 GenPreSQL

This is the Generate PreSQL option of the entity. DATATYPE: Boolean.

 GoogleBigqueryExpirationTimestamp

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

 GoogleBigqueryKmsKeyName

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

 GoogleBigqueryLabels

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

 GoogleBigqueryPartitionExpirationTimestamp

This is the date 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

This is the time 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

This is the type Type of partitioning used to partition Google BigQuery tables. DATATYPE: String.

 GoogleBigqueryRangeFields

This is the range Range used to partition Google BigQuery tables. DATATYPE: String.

 GreenplumDistributionColumns

This is the Greenplum only. GreenplumDistributionColumns property of the table. It applies only to Greenplum. DATATYPE: String.

 GreenplumDistributionRandom

This is the Greenplum only. GreenplumDistributionRandom property of the table. It applies only to Greenplum. DATATYPE: Boolean.

 GrowthPeriod

This is the period the growth Physical models only. Period the growth rate is based on. The value of this property can be one of these: Valid strings are Day, Week, Month, Quarter, or Year. This property applies only to physical models. DATATYPE: String.

 GrowthRate

This determines Physical models only. Determines how fast a table will grow. This property applies only to physical models. grows. DATATYPE: Integer.

 GrowthType

This is the the type the Physical models only. Type on which the growth rate is based on. The value of this property can be either . Valid strings are Percent or Rows. This property applies only to physical models. DATATYPE: String.

 GUID

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

 HiRDBFix

This is the Fix option of the entity storage. DATATYPE: Boolean.

 HiRDBRowLock

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

 HiRDBStorageIn

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

 HiveAsSelect

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

 HiveClusteredByColumns

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

 HiveExternalTable

This is the Hive only. External property of the table. If true, the table with be is created extenallyexternally: CREATE EXTERNAL TABLE ... It applies only to Hive models... DATATYPE: Boolean.

 HiveLocation

This property determines Hive only. Determines where the table will be is stored in the HDFS. It applies only to Hive models. DATATYPE: String.

 HiveNumBuckets

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

 HiveRowFormatCollections

This property corresponds Hive only. Corresponds to COLLECTION ITEMS TERMINATED BY of the ROW FORMAT clause in the create table statement. It requires HiveRowFormatDelimited to be true. It applies only to Hive modelsa true HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatDelimited

This Hive only property pertains . Pertains to the RowFormat of the table. If true, the table will be is created with ROW FORMAT DELIMITED. Cannot be You cannot set to true if a RowFormat SerDe has been is specified ( via HiveStoredBySerDeHandler). DATATYPE: Boolean.

 HiveRowFormatEscapedBy

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

 HiveRowFormatFields

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

 HiveRowFormatLines

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

 HiveRowFormatMapKeys

This property corresponds Hive only. Corresponds to MAP KEYS TERMINATED BY of the ROW FORMAT clause in the create table statement. It requires HiveRowFormatDelimited to be true. It applies only to Hive modelsa true HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatNullDefinedBy

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

 HiveRowFormatSerDeHandler

This property is the name Hive only. Name of the SerDe handler for ROW FORMAT. It requires HiveRowFormatDelimited to be false. It applies only to Hive modelsa false HiveRowFormatDelimited. DATATYPE: String.

 HiveRowFormatSerDeProperties

This property holds Hive only. Holds the comma-separated properties for ROW FORMAT SerDe. It requires HiveRowFormatSerDeHandler to be set. It applies only to Hive models. It requires a set HiveRowFormatSerDeHandler. DATATYPE: String.

 HiveSkewedByColumns

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

 HiveSkewedByValues

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

 HiveSortedByColumns

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

 HiveStoredAs

Hive only. Is file format in the STORED AS clause. Valid input: , 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. This is the 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. This is the 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

This Hive only property is the name . Name of the SerDe handler that would appear appears in the STORED BY clause of the Create Table statement. It requires HiveStoredAs to be an empty HiveStoredAs. DATATYPE: String.

 HiveStoredBySerDeProperties

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

 HiveTblProperties

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

 ID

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

 IndexTablespace

This property specifies Specifies the Tablespace in which to create the Index for this table will be created. DATATYPE: String.

 InformixLockMode

This is the InformixLockMode property of the table. It applies to Informix Online and Informix 9.x or and later versions. DATATYPE: Integeronly. InformixLockMode property of the table. Possible values : include 0 for = PAGE and 1 for = ROW. DATATYPE: Integer. 

 InitialExtent

This is the initial Initial extent of the entity storage. DATATYPE: Integer.

 InitTransactions

This is the Initial Transactions of the entity storage. DATATYPE: Integer.

 InterModelID

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

 IsStatic

This determines if Physical models only. Determines whether a table is a static table or it will grow. This property applies only to physical models. DATATYPE: Boolean.

 LastSourced

This property is for Applies to DataLineage and applies displays when the data was last sourced only if the parent model is physical and has been is enabled for data movement. This property tells when the data was last sourceddata 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

This property identifies Identifies the Tablespace in which the values of any long columns will be are stored. DATATYPE: String.

 MaxExtents

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

 MaximumRows

This is the maximum Physical models only. Maximum number of rows a table can hold. This property applies only to physical models. DATATYPE: Integer.

 MaxTransactions

This is the MaxTransactions of the entity storage. DATATYPE: Integer.

 MinExtents

This is the MinExtents of the entity storage. DATATYPE: Integer.

 MySQLTableType

This is the type Type of the table for MySQL model. The possible values Valid strings are MYISAM or 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

This is the NetezzaDistributionColumns property of the table. It applies only to Netezza 4.6, 5.0 and later versionsonly. NetezzaDistributionColumns property of the table. DATATYPE: String.

 NetezzaDistributionRandom

This is the NetezzaDistributionRandom property of the table. It applies only to Netezza 4.6, 5.0 and later versionsonly. NetezzaDistributionRandom property of the table. DATATYPE: Boolean.

 NetezzaOrganizationColumns

This is the Netezza 6.0 and later only. Organization Key property of the table and contains up to four comma-separated columns. It applies to Netezza 6. 0 or later. DATATYPE: String.

 NextExtent

This is the next Next extent of the entity storage. DATATYPE: Integer.

 NoLogging

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

 Note

This is the note Note of the entity. DATATYPE: String.

 OracleAccessDriver

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

 OracleAccessParameters

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

 OracleBufferPool

This is the BufferPool of the entity storage. Values can be Valid strings are KEEP, RECYCLE, DEFAULT or , and NONE. DATATYPE: String.

 OracleCache

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

 OracleDefaultDirectory

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

 OracleExternalTables

This is used to set/unset Sets/unsets the Oracle External Table property.

 OracleExtLocation

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

 OracleDegrees

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

 OracleIndex

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

 OracleInstances

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

 OracleParallel

This is the Parallel option of the entity storage. DATATYPE: Boolean.

 OracleRowMovement

This is the Oracle 9 and later only. OracleRowMovement property of the table. It applies only to Oracle 9 and later versions, and it is not Not supported for non-partitioned index-organized tables. DATATYPE: Boolean.

 Owner

This is the owner Owner of the entity. DATATYPE: String.

 PctFree

This is the percent Percent free of the entity storage. DATATYPE: Integer.

 PctIncrease

This is the percent Percent increase of the entity storage. DATATYPE: Integer.

 PctUsed

This is the percent Percent used by the entity storage. DATATYPE: Integer.

 Persistence

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

 PostSQL

This is the PostSQL of the entity. DATATYPE: String.

 PreSQL

This is the PreSQL of the entity. DATATYPE: String.

 RowCount

This is the current Physical models only. Current number of rows in a table. This property applies only to physical models. DATATYPE: Integer.

 SourcingFrequency

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

 StorageLocation

This is the storage Storage location of the entity. DATATYPE: String.

 SybaseIdentityGap

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

 SybaseLockingScheme

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

 SybaseMaxRowsPerPage

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

 SybasePrefetchStrategyOn

This is the 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

This is the 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

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

 SystemName

This is the system System name of the AS400 table. DATATYPE: String.

 TableDDL

This is the TableDDL of the entity. DATATYPE: String.

 TableName

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

 TeradataAfterJournal

This is the 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

This is the 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

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

 TeradataDatablockSize

This is the 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

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

 TeradataFallback

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

 TeradataJournalName

This is the 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

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

 TextLabel

This is the text Text label of the AS400 table. DATATYPE: String.