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

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 if this table is compressed.	int
IsDBMSView	This attribute indicates if this PhysicalTable object represents a view in the DBMS.	int
IsEncrypted	This attribute indicates if the table is encrypted.	int
SASTableName	This is the name SAS software uses to refer to the table.	String	32

Inherited Attributes
Name Id Desc MetadataCreated MetadataUpdated ChangeState 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 , 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 if this table is compressed.

IsDBMSView
     Type: int
This attribute indicates if this PhysicalTable object represents a view in the DBMS.

IsEncrypted
     Type: int
This attribute indicates if this table is encrypted.

SASTableName
     Type: String 32
This is the name that SAS software uses to refer to the table. Typically, the SAS name is 32 characters in length and conforms to SAS naming restrictions; for example, no spaces or special characters.
This attribute can support mixed-case names and special characters and spaces in the text, if you define a PropertySet object and one or two Property objects to indicate that this table requires special handling for its names. The PropertySet object should include the attributes Name=DBMSNames and SetRole=DBMSNames and define two properties: Case and SpecChar. Case signifies that the values in the SASTableName/SASColumnName attribute are case-sensitive. SpecChar signifies 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