SAS Namespace Types |
Subclass of Key
Represents the fact that a table contains a foreign key to another table.
The following list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.
Inherited Attributes
Name, Id, Desc, MetadataCreated,
MetadataUpdated,
ChangeState,
LockedBy,
UsageVersion
Name | Cardinality | Description | Associated Types |
KeyAssociations Partner: OwningForeignKey | 0 to * | The list of association object s that associate a column in this foreign key to a column in the unique key. | KeyAssociation |
PartnerUniqueKey Partner: ForeignKeys | 0 to 1 | The unique key associated with this foreign key. | UniqueKey |
Table Partner: ForeignKeys | 1 to 1 | The table that contains this foreign key. |
DataTable ExternalTable JoinTable PhysicalTable QueryTable RelationalTable TableCollection WorkTable |
Inherited Associations
AccessControls/Objects,
Changes/Objects,
CustomAssociations/OwningObject,
DisplayColumns/DisplayForKeys,
Documents/Objects,
Extensions/OwningObject,
ExternalIdentities/OwningObject,
Groups/Members,
Implementors/ImplementedObjects,
KeyedColumns/Keys,
Keywords/Objects,
LocalizedAttributes/AssociatedLocalizedObject,
Notes/Objects,
PrimaryPropertyGroup/AssociatedObject,
Prompts/PromptEnabledObject,
Properties/AssociatedObject,
PropertySets/OwningObject,
ReferencedObjects/AssociatedObjects,
ResponsibleParties/Objects,
SourceTransformations/TransformationSources,
SpecSourceTransformations/SourceSpecifications,
SpecTargetTransformations/TargetSpecifications,
TargetTransformations/TransformationTargets,
Timestamps/Objects,
Trees/Members,
TSObjectNamespace/TSObjects,
UsedByPrototypes/UsingPrototype,
UsingPrototype/UsedByPrototypes,
Variables/AssociatedObject
KeyAssociations
Cardinality: 0 to *
Partner: OwningForeignKey
The list of association objects that associate a column in this foreign key to a column in the unique key.
Associated Types:
KeyAssociationPartnerUniqueKey
Cardinality: 0 to 1
Partner: ForeignKeys
The unique key associated with this foreign key.
Associated Types:
UniqueKeyTable
Cardinality: 1 to 1
Partner: ForeignKeys
The table that contains this foreign key.
Associated Types:
DataTable, ExternalTable, JoinTable, PhysicalTable, QueryTable, RelationalTable, TableCollection, WorkTable
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.