space
Previous Page | Next Page

SAS Namespace Types

PhysicalTable


Subclass of RelationalTable

Subtypes


Overview

A "materialized" table that resides in a database or a file system.

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
DBMSType If this table resides in a DBMS, this attribute describes the type of the DBMS. These types are the same as the SAS engine types.   String 64  
IsCompressed This attribute indicates whether this table is compressed or not.   int  
IsDBMSView This attribute indicates that this physical table object represents a view in the DBMS.   int  
IsEncrypted Is the table encrypted?   int  
SASTableName This is name SAS software uses to refer to the table. String 32  

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, IsHidden, LockedBy, MemberType, NumRows, PublicType, TableName, 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
Aggregations

Partner: AggregationTables

0 to * The aggregations associated with this table.  Aggregation
Indexes

Partner: OwningPhysicalTable

0 to * The list of indexes for this table.  Index
ReachThruCubes

Partner: ReachThruTables

0 to * The cubes that use this table for reachthru.  Cube
SASPasswords

Partner: ProtectedTable

0 to * The list of passwords used with this table.   SASPassword
TrainedModelResults

Partner: TrainingTable

0 to * The mining results associated with this training table.  MiningResult

Inherited Associations
AccessControls/Objects, AnalyticTables/AnalyticTrainingTable, AssociatedXMLMap/XMLMapTables, Changes/Objects, Columns/Table, CustomAssociations/OwningObject, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, FavoritesContainers/Favorites, ForeignKeys/Table, Groups/Members, Implementors/ImplementedObjects, Keywords/Objects, LocalizedAttributes/AssociatedLocalizedObject, ModelResults/TargetTable, Notes/Objects, PrimaryPropertyGroup/AssociatedObject, Prompts/PromptEnabledObject, Properties/AssociatedObject, PropertySets/OwningObject, ReferencedObjects/AssociatedObjects, ResponsibleParties/Objects, Roles/RoleObject, SourceClassifierMaps/ClassifierSources, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, TableCollections/Tables, TablePackage/Tables, TargetClassifierMaps/ClassifierTargets, TargetTransformations/TransformationTargets, Timestamps/Objects, Trees/Members, TSObjectNamespace/TSObjects, UniqueKeys/Table, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject, XPaths/AssociatedMapTable

Attribute Details

DBMSType
     Type:  String 64  

If this table resides in a DBMS, this attribute describes the type of the DBMS. These types are the same as the SAS engine types.

IsCompressed
     Type:  int  

This attribute indicates whether this table is compressed or not.

IsDBMSView
     Type:  int  

This attribute indicates that this physical table object represents a view in the DBMS.

IsEncrypted
     Type:  int  

Is the table encrypted?

SASTableName
     Type:  String 32  

This is name SAS software uses to refer to the table. Typically the SAS name is 32 characters in length and conforms to the SAS naming restrictions, for example, no space or special characters.

This attribute can support mixed-case names, special characters, and spaces in the text, if there is a property set and one or two properties are configured on the table to indicate that this table requires special handling for its names.

In order to support special characters and spaces, as well as the ability to support case-sensitive names in the text of this attribute, a PropertySet must be attached to the table. The PropertySet is named DBMSNames with a SetRole="DBMSNames". This set can contain two properties: Case and SpecChar. Case is used to indicate if the values in the SASTableName/SASColumnName attribute are case-sensitive or not. SpecChar is used to indicate if the values in the SASTableName/SASColumnName can contain special characters, including spaces.

Association Details

Aggregations
     Cardinality:   0 to *
     Partner:  AggregationTables

The aggregations associated with this table. 

Associated Types:
Aggregation

Indexes
     Cardinality:   0 to *
     Partner:   OwningPhysicalTable

The list of indexes for this table. 

Associated Types:
Index

ReachThruCubes
     Cardinality:   0 to *
     Partner:   ReachThruTables

The cubes that use this table for reachthru. 

Associated Types:
Cube

SASPasswords
     Cardinality:   0 to *
     Partner:   ProtectedTable

The list of passwords used with this table. 

Associated Types:
SASPassword

TrainedModelResults
     Cardinality:   0 to *
     Partner:   TrainingTable

The mining results associated with this training table. 

Associated Types:
MiningResult

Previous Page | Next Page | Top of Page