SAS Namespace Types |
Subclass of RelationalTable
Subtypes
A "materialized" table that resides in a database or a file system.
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.
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
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
DBMSType
Type: String 64If 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: intThis attribute indicates whether this table is compressed or not.
IsDBMSView
Type: intThis attribute indicates that this physical table object represents a view in the DBMS.
IsEncrypted
Type: intIs the table encrypted?
SASTableName
Type: String 32This 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.
Aggregations
Cardinality: 0 to *
Partner: AggregationTables
The aggregations associated with this table.
Associated Types:
AggregationIndexes
Cardinality: 0 to *
Partner: OwningPhysicalTable
The list of indexes for this table.
Associated Types:
IndexReachThruCubes
Cardinality: 0 to *
Partner: ReachThruTables
The cubes that use this table for reachthru.
Associated Types:
CubeSASPasswords
Cardinality: 0 to *
Partner: ProtectedTable
The list of passwords used with this table.
Associated Types:
SASPasswordTrainedModelResults
Cardinality: 0 to *
Partner: TrainingTable
The mining results associated with this training table.
Associated Types:
MiningResult
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.