SAS Namespace Types

PhysicalTable

Subclass of RelationalTable

Subtypes

WorkTable

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.

ModelResults
TablePackage: Enforce both sides
Trees

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, SecTransctxt, 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

Top of Page