space
Previous Page | Next Page

SAS Namespace Types

DataTable


Subclass of Classifier

Subtypes


Overview

An abstract type that represents an object that contains a set of columns. When creating metadata, use the subtype of DataTable that best describes the entity that you want to represent.

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
NumRows This attribute contains the number of rows of data in the table. It can be filled in at data loading time to indicate to the metadata consumers how many rows of data a table has in it. If the number of rows is unknown, then a -1 is returned.   double  
TableName This is the DBMS name for tables in an external database or the SAS dataset name.   String 256  

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, IsHidden, LockedBy, PublicType, SecTransctxt, 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
ColumnHierarchies

Partner: AssociatedDataTable

0 to * The column hierarchies defined for this table.  ColumnHierarchy
Columns

Partner: Table

0 to * The list of columns contained in this table.  Column
ColumnRange
ForeignKeys

Partner: Table

0 to * The foreign keys associated with a table.  ForeignKey
Roles

Partner: RoleObject

0 to * The roles an object can play.  Role
TableCollections

Partner: Tables

0 to * The table collections where this data table participates.  TableCollection
TablePackage

Partner: Tables

0 to 1 The data packages (schema or libraries) that can be used to reference this table.   RelationalSchema
DatabaseSchema
DataSourceName
SASLibrary
SecuredLibrary
UniqueKeys

Partner: Table

0 to * The list of unique keys associated with a table.  UniqueKey

Inherited Associations
AccessControls/Objects, Changes/Objects, CustomAssociations/OwningObject, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, FavoritesContainers/Favorites, Groups/Members, Implementors/ImplementedObjects, Keywords/Objects, LocalizedAttributes/AssociatedLocalizedObject, Notes/Objects, PrimaryPropertyGroup/AssociatedObject, Prompts/PromptEnabledObject, Properties/AssociatedObject, PropertySets/OwningObject, ReferencedObjects/AssociatedObjects, ResponsibleParties/Objects, SourceClassifierMaps/ClassifierSources, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, TargetClassifierMaps/ClassifierTargets, TargetTransformations/TransformationTargets, Timestamps/Objects, Trees/Members, TSObjectNamespace/TSObjects, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject

Attribute Details

NumRows
     Type:  double  

This attribute contains the number of rows of data in the table. It can be filled in at data loading time to indicate to the metadata consumers how many rows of data a table has in it. If the number of rows is unknown, then a -1 is returned.

TableName
     Type:  String 256  

This is the DBMS name for tables in an external database or the SAS dataset name.

Association Details

ColumnHierarchies
     Cardinality:   0 to *
     Partner:  AssociatedDataTable

The column hierarchies defined for this table. 

Associated Types:
ColumnHierarchy

Columns
     Cardinality:   0 to *
     Partner:  Table

The list of columns contained in this table. 

Associated Types:
Column, ColumnRange

ForeignKeys
     Cardinality:   0 to *
     Partner:   Table

The foreign keys associated with a table. 

Associated Types:
ForeignKey

Roles
     Cardinality:   0 to *
     Partner:   RoleObject

The roles an object can play. 

Associated Types:
Role

TableCollections
     Cardinality:   0 to *
     Partner:   Tables

The table collections where this data table participates. 

Associated Types:
TableCollection

TablePackage
     Cardinality:   0 to 1
     Partner:  Tables

The data packages (schema or libraries) that can be used to reference this table.  

Associated Types:
RelationalSchema, DatabaseSchema, DataSourceName, SASLibrary

UniqueKeys
     Cardinality:   0 to *
     Partner:  Table

The list of unique keys associated with a table. 

Associated Types:
UniqueKey

Previous Page | Next Page | Top of Page