SAS Namespace Hierarchy and Association Diagrams

Diagrams for Relational Metadata Types

Key Hierarchy

The Key Hierarchy Diagram depicts the hierarchy of the metadata types that represent relational keys.

Key Hierarchy Diagram

[Key Hierarchy Diagram]

Column Hierarchy

The Column Hierarchy Diagram depicts the type hierarchy of the metadata types that represent relational columns.

Column Hierarchy Diagram

[Column Hierarchy Diagram]

Table Hierarchy

The Table Hierarchy Diagram depicts the hierarchy of the metadata types that represent tables.

Table Hierarchy Diagram

[Table Hierarchy Diagram]

DataTable is an abstract metadata type that models the properties for three classes of subtypes: ExternalTable, RelationalTable, and TableCollection. RelationalTable has as subtypes QueryTable, PhysicalTable, JoinTable, and WorkTable, which also inherit from each other.

Database Schema Hierarchy

The Database Schema Hierarchy depicts the hierarchy of the metadata types that represent a relational schema.

Database Schema Hierarchy Diagram

[DeployedDataPackage Hierarchy Diagram]

Schema, Table, Role, and Column Associations

The Schema, Table, Role, and Column Associations Diagram illustrates the associations between the DatabaseCatalog, RelationalSchema, Role, DataTable, and Column metadata types.

Schema, Table, Role, and Column Associations Diagram

[DeployedDataPackage Hierarchy Diagram]

Table, Password, and Index Associations

The Table, Password, and Index Associations Diagram illustrates the associations between the PhysicalTable, SASPassword, Index, and Column metadata types.

Table, Password, and Index Associations Diagram

[Table, Password, and Index Associations Diagram]

Table and Key Associations

The Table and Key Associations Diagram illustrates the associations between the DataTable, Column, Key, KeyAssociation, ForiegnKey, and PrimaryKey metadata types.

Table and Key Associations Diagram

[Table and Key Associations Diagram]

TKTS Data Source Name Associations

The TKTS Data Source Name Associations Diagram illustrates the associations between RelationalSchema, DataSourceName, Login, and Connection metadata types.

TKTS Data Source Name Associations Diagram

[TKTS Data Source Name Associations Diagram]

Table Collection Associations

The Table Collection Associations Diagram illustrates the associations between the DataTable, Column, TableCollection, DeployedDataPackage, ContentLocation and RelationalSchema metadata types and some of their subtypes.

Table Collection Associations Diagram

[Table Collection Associations Diagram]

SecuredLibrary and SecuredTable Associations

The SecuredLibrary and SecuredTable Associations Diagram illustrates the associations between the SecuredLibrary and SecuredTable metadata types, the other library and table types, and the SASPassword metadata type.

SecuredLibrary and SecuredTable Associations Diagram

[Table Collection Associations Diagram]

Top of Page