SAS Namespace Types

UniqueKey

Subclass of Key

Overview

A representation of the unique and primary keys of a table. It is also associated with the columns in the table that comprise the key.

Security Inheritance and Enforcement Rules

The following is a list of associations that are used to determine if this object should inherit access controls from another object (inheritance) or if the association is allowed for the object (enforcement). For more information about inheritance and enforcement rules, see the SAS 9.2 Intelligence Platform: Security Administration Guide.

Table

Attributes

Name	Description	Type	Length
IsPrimary	If the key is a primary key, the value of this attribute should be true. The default value is false.	int

Inherited Attributes
Name Id Desc MetadataCreated MetadataUpdated ChangeState LockedBy 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
ForeignKeys Partner: PartnerUniqueKey	0 to *	The list of foreign keys that are associated with this unique key.	ForeignKey
Table Partner: UniqueKeys	1 to 1	The table that owns this unique 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

Attribute Details

IsPrimary
Type: int
If the key is a primary key, the value of this attribute should be true. The default value is false.

Association Details

ForeignKeys
     Cardinality: 0 to *
     Partner: PartnerUniqueKey

The list of foreign keys that are associated with this unique key.

Associated Types:
ForeignKey

Table
     Cardinality: 1 to 1
     Partner: UniqueKeys

The table that owns this unique key.

Associated Types:
DataTable ExternalTable JoinTable PhysicalTable QueryTable RelationalTable TableCollection WorkTable

Top of Page