space
Previous Page | Next Page

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 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.

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

Previous Page | Next Page | Top of Page