Key_Group (object)

Identifies relationships between entities that are implemented as foreign keys in a logical model. You can also use key groups to identify potential primary keys or alternate keys for use in the physical model.

Valid Owning Object Types

Name DBMS Brands/Versions
Auxiliary_TableDB2 for z/OS 8.1+
Cached_ViewDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Oracle 8.0+, Teradata 2.6+
EntityAll
ViewOracle 9.0+, SQL Server 9.0+, SQL Azure 10.0+

Valid Owned Object Types

Name DBMS Brands/Versions
Extended_NotesAll
Key_Group_MemberAll
Oracle_Attribute_StorageOracle 8.0+
Oracle_Constraint_StateOracle 8.0+
Oracle_Index_Global_PartitionOracle 8.0+
Oracle_Index_Local_PartitionOracle 8.0+
Partition_ColumnOracle 10.0+, SQL Server 9.0+
Partition_ElementDB2 for z/OS 8.1+, Informix 7.0+
PermissionDB2 for LUW 9.1+, Teradata 2.5+
SQLServer_Data_CompressionSQL Server 10.0+

Tagged Values

Name Value
Long_Id{E7AB3CC0-47AD-4A10-8972-C0FB869EE7CB}+40200009
tag_Display_Name_ResourceKey Group
tag_Display_Name_Resource_PluralKey Groups
tag_Has_Udp_Editortrue
tag_Is_Abstractfalse
tag_Is_Logicaltrue
tag_Is_Physicaltrue
tag_Is_Transformabletrue
tag_Legacy_Object_Is_Dependenttrue
tag_Legacy_Ownership_Depth256
tag_Physical_Name_TextIndex
tag_Physical_Name_Text_PluralIndexes

Valid Property Types

Name DBMS Brands/Versions
Allow_Index_Reverse_ScansDB2 for LUW 8.1+, SAS 1.0+
Allow_Page_LocksSQL Server 9.0+
Allow_Row_LocksSQL Server 9.0+
Are_Nulls_EqualDB2 for LUW 2.0-8.0, DB2 for z/OS 6.0+, DB2 for i 4.0+
Available_Filegroups_RefSQL Server 9.0+
Built_In_IdAll
Collect_Statistics_TypeDB2 for LUW 9.1+
CommentAll
Constraint_NameDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Oracle 8.1+, SQL Server 9.0+, Teradata 2.6+, SQL Azure 10.0+
DB2_CloseDB2 for LUW 2.0-8.0, DB2 for z/OS 6.0+
DB2_Copy_IndexDB2 for z/OS 6.0+
DB2_DeferDB2 for z/OS 6.0+
DB2_Define_Data_SetsDB2 for z/OS 8.1+
DB2_Erase_When_DeletedDB2 for z/OS 8.1+
DB2_Free_Page_IntervalDB2 for z/OS 8.1+
DB2_Group_Bufferpool_TypeDB2 for z/OS 8.1+
DB2_Object_IdDB2 for z/OS 2.0+
DB2_Percent_FreeDB2 for z/OS 8.1+
DB2_Piece_SizeDB2 for z/OS 6.0+
DB2_Primary_Space_AllocationDB2 for z/OS 8.1+
DB2_Secondary_Space_AllocationDB2 for z/OS 8.1+
DB2_Storage_Group_RefDB2 for z/OS 8.1+
DB2_SubPagesDB2 for z/OS 0.0-5.0
DB2_TypeDB2 for z/OS 8.1+
DB2_Use_BufferpoolDB2 for z/OS 8.1+
DB2_Volume_CatalogDB2 for z/OS 8.1+
Database_IdDB2 for LUW 9.1+
DefinitionAll
Dependent_Objects_RefAll
Do_Not_GenerateAll
For_Clause_ExpressionFoxPro 1.0+
Generate_As_ConstraintDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Oracle 8.1+, SQL Server 9.0+, Teradata 2.6+, SQL Azure 10.0+
Hide_In_LogicalAll
Hide_In_PhysicalAll
History_ListAll
Ignore_NullsAccess 9.0+
Include_Columns_RefDB2 for LUW 9.1+, SQL Server 9.0+, SQL Azure 10.0+
Index_Extension_ExpressionsDB2 for LUW 9.1+
Index_Extension_RefDB2 for LUW 9.1+
Index_File_NameFoxPro 1.0+
Index_Members_Order_RefAll
Informix_DBSpace_RefInformix 7.0+
Informix_Storage_OptionInformix 7.0+
Ingres_AllocationIngres 2.5+
Ingres_Compress_DataIngres 2.5+
Ingres_Compress_HidataIngres 2.5+
Ingres_Compress_KeyIngres 2.5+
Ingres_Compression_TypeIngres 2.5+
Ingres_ExtendIngres 2.5+
Ingres_Fill_FactorIngres 2.5+
Ingres_Index_RangeIngres 2.5+
Ingres_Leaf_FillIngres 2.5+
Ingres_LocationsIngres 2.5+
Ingres_Max_PagesIngres 2.5+
Ingres_Min_PagesIngres 2.5+
Ingres_Non_Leaf_FillIngres 2.5+
Ingres_Page_SizeIngres 2.5+
Ingres_PersistenceIngres 2.5+
Ingres_Range_Max_XIngres 2.5+
Ingres_Range_Max_YIngres 2.5+
Ingres_Range_Min_XIngres 2.5+
Ingres_Range_Min_YIngres 2.5+
Ingres_Structure_TypeIngres 2.5+
Ingres_Unique_Scope_TypeIngres 2.5+
Ingres_Use_Compress_KeyIngres 2.5+
Ingres_Use_RangeIngres 2.5+
Is_AscendingFoxPro 1.0+, ODBC 2.0+
Is_Bitmap_IndexOracle 8.0+
Is_CalculatedAll
Is_ClusteredAccess 9.0+, DB2 for LUW 8.1+, DB2 for z/OS 6.0+, Informix 5.0+, Progress 8.0+, SQL Server 7.0+, Sybase 12.5+, Teradata 2.0+, SQL Azure 10.0+
Is_CompressedDB2 for LUW 9.7+, DB2 for z/OS 9.1+
Is_DisabledOracle 9.0+, SQL Server 9.0+, SQL Azure 10.0+
Is_EnabledOracle 8.0+
Is_EnforcedDB2 for LUW 9.1+
Is_Index_CompactedFoxPro 1.0+
Is_Index_CompoundFoxPro 1.0+
Is_Logical_OnlyAll
Is_PartitionedDB2 for LUW 9.7+, DB2 for z/OS 8.1+
Is_Physical_OnlyAll
Is_Primary_IndexTeradata 2.5+
Is_Query_Optimization_DisabledDB2 for LUW 9.1+
Is_UniqueAll
Is_UnnamedTeradata 2.6+
Key_ExpressionFoxPro 1.0+
Key_Group_Members_Order_RefAll
Key_Group_TypeAll
Long_IdAll
Minimum_Percent_UsedDB2 for LUW 9.1+
NameAll
Name_QualifierAll
Note_ListAll
Object_GUIDAll
OnlineOracle 8.0+, SQL Server 9.0+, SQL Azure 10.0+
Oracle_Index_Partition_TypeOracle 8.0+
Owner_PathAll
Pad_Variable_Length_ColumnsDB2 for z/OS 8.1+
Partition_Columns_Order_RefSQL Server 9.0+
Partition_Elements_Order_RefDB2 for z/OS 8.1+, SQL Server 9.0+
Physical_NameAll
Progress_AbbreviatedProgress 8.0+
Progress_ActiveProgress 8.0+
Progress_Area_RefProgress 9.0+
Progress_WordProgress 8.0+
Relationship_RefAll
Remainder_In_Informix_DBSpace_RefInformix 7.0+
SQLServer_Drop_Existing_IndexSQL Server 7.0+, SQL Azure 10.0+
SQLServer_Filegroup_RefSQL Server 7.0+
SQLServer_Filestream_Filegroup_RefSQL Server 10.0+
SQLServer_Filestream_Partition_Scheme_RefSQL Server 10.0+
SQLServer_Fill_FactorSQL Server 7.0+, Sybase 12.5+
SQLServer_Ignore_Duplicate_KeysSQL Server 7.0+, Sybase 12.5+, SQL Azure 10.0+
SQLServer_Is_Data_SortedSQL Server 7.0+, Sybase 12.5+
SQLServer_Keep_Existing_StatisticsSQL Server 7.0+, SQL Azure 10.0+
SQLServer_Max_ParallelSQL Server 9.0+
SQLServer_Pad_IndexSQL Server 7.0+
SQLServer_Partition_Scheme_RefSQL Server 9.0+
SQLServer_Sort_In_Temp_DBSQL Server 9.0+
Schema_NameAccess 9.0+, DB2 for LUW 8.1-8.1, DB2 for z/OS 6.0-8.0, FoxPro 1.0+, Informix 9.2+, ODBC 2.0+, Oracle 8.0+, Progress 8.0+, Red Brick 5.0+, SAS 1.0+, SQL Server 7.0-8.0, Sybase 12.5+, DB2 for i 4.0+, Sybase IQ 12.5+, MySQL 5.0+
Schema_RefDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Teradata 2.6+
SybaseIQ_Index_TypeSybase IQ 12.5+
SybaseIQ_Word_DelimiterSybase IQ 12.5+
SybaseIQ_Word_LimitSybase IQ 12.5+
Sybase_Duplicate_Index_Row_ModeSQL Server 7.0+, Sybase 12.5+
Sybase_Max_RowsSybase 12.5+
Sybase_Reserve_Page_GapSybase 12.5+
Sybase_Segment_RefSybase 12.5+
Teradata_FallbackTeradata 2.0+
Teradata_Maintain_Logical_Row_IdTeradata 2.5+
Teradata_Order_ByTeradata 2.5+
Teradata_Order_By_Columns_RefTeradata 2.5+
Teradata_Partitioning_ExpressionTeradata 2.5+
UDB_Level2_Percent_FreeDB2 for LUW 9.1+
UDB_Page_Split_TypeDB2 for LUW 9.1+
UDB_Percent_FreeDB2 for LUW 5.2+
UDB_Tablespace_RefDB2 for LUW 9.1+
Update_Key_Group_Definition_To_MatchAll
User_Formatted_NameAll
User_Formatted_Physical_NameAll
Where_ClauseSQL Server 10.0+, SQL Azure 10.0+