DDL File Relationship Projections

Statement Format Relationship Entities
ALTER TABLE
ALTER TABLE 
<table-name> …
DDL File Refers To Table

Table attributes:

  • Name = <table-name>
  • Is View = False
COMMENT
COMMENT ON [TABLE] 
<table-name> …
DDL File Refers To Table

Table.Name = <table-name>

CREATE ALIAS
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
CREATE INDEX 
<index-name> ON <table-name> … 
				
DDL File Refers To Table

Table.Name = <table-name>

CREATE SYNONYM
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
CREATE TABLE <table-name>...
         [IN [DATABASE] [<database>.] <tablespace>]
DDL File Defines Table

Table attributes:

  • Database
  • TableSpace
  • Name = <table-name>
  • Is View = False
  • Source = "DBSchema.mdb"
  • Origin = <source-file-path>
CREATE PROCEDURE
CREATE (OR REPLACE)? PROCEDURE <procedure-name> …

DDL File Defines Stored Procedure

Program Entry Point:
  • Name = procedure-name
  • MainEntry = false
CREATE VIEW
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>
Referential constraint
FOREIGN KEY key 
REFERENCES <base-table>…
DDL File Refers To Table

Table.Name = <base-table>

SET CURRENT SQLID
SET CURRENT SQLID = 'user-name'
 

sqlid = <user-name>