SAS Namespace Types

ForeignKey

Subclass of Key

Overview

Represents the fact that a table contains a foreign key to another table.

Security Inheritance and Enforcement Rules

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.

Table

Attributes

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, LockedBy, SecTransctxt, UsageVersion

Associations

= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.

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

Association Details

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:
KeyAssociation

PartnerUniqueKey
     Cardinality: 0 to 1
     Partner: ForeignKeys

The unique key associated with this foreign key.

Associated Types:
UniqueKey

Table
     Cardinality: 1 to 1
     Partner: ForeignKeys

The table that contains this foreign key.

Associated Types:
DataTable, ExternalTable, JoinTable, PhysicalTable, QueryTable, RelationalTable, TableCollection, WorkTable

Top of Page