DDL File Relationship Projections

ALTER TABLE 
<table-name> …

Table attributes:

• Name = <table-name>
• Is View = False

COMMENT ON [TABLE] 
<table-name> …

Table.Name = <table-name>

CREATE ALIAS 
<alias-name> ON <table-name> …

DDL File Defines Table

Table Represents Table

Table attributes:

• Name = <alias-name>
• Is View = True
• IsAlias = True
• Source = "DBSchema.mdb’
• Origin = <source-file-path>
• Table.Name = <table-name>

CREATE INDEX 
<index-name> ON <table-name> … 
				

Table.Name = <table-name>

CREATE SYNONYM <ViewName> FOR <TableName>

DDL File Defines Table

Table Represents Table

Table attributes:

• Name = <synonym>
• Is View = True
• IsAlias = True
• Source = "DBSchema.mdb"
• Origin = <source-file-path>
• Table.Name = <table-name>

CREATE TABLE <table-name>...
         [IN [DATABASE] [<database>.] <tablespace>]

Table attributes:

• Database
• TableSpace
• Name = <table-name>
• Is View = False
• Source = "DBSchema.mdb"
• Origin = <source-file-path>

CREATE (OR REPLACE)? PROCEDURE <procedure-name> …

DDL File Defines Stored Procedure

• Name = procedure-name
• MainEntry = false

CREATE VIEW <view-name> …AS 
SELECT … FROM <table-name>

DDL File Defines Table

Table Represents Table

Table attributes:

• Name = <view-name>
• Is View = True
• Source = "DBSchema.mdb"
• Origin = <source-file-path>
• Table.Name = <table-name>

FOREIGN KEY key 
REFERENCES <base-table>…

Table.Name = <base-table>

SET CURRENT SQLID = 'user-name'

sqlid = <user-name>