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.

TablePackage: Enforce both sides
Trees

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

Top of Page