| Statement | Format | Relationship | Entities |
|---|---|---|---|
| ALTER TABLE |
ALTER TABLE <table-name> … |
Program Manipulates Table | Table.Name = <table-name> |
| CALL |
EXEC SQL CALL <procedure-name> … |
PROGRAM Calls Program Entry Point | Program Entry Point:
|
| CREATE INDEX |
CREATE INDEX <index-name> ON <table-name> … |
Program Manipulates Table | Table.Name = <table-name> |
| CREATE TABLE |
CREATE TABLE <table-name>...
[IN [DATABASE] [<database>.] <tablespace>]
|
Program Manipulates Table |
Table attributes:
|
| CREATE PROCEDURE |
CREATE [OR REPLACE] PROCEDURE <procedure-name> … |
Program Defines Stored Procedure | Program Entry Point:
|
| DELETE |
DELETE FROM <table-name>… |
Program Deletes From Table | Table.Name = <table-name> |
| DROP TABLE |
DROP TABLE <table-name> |
Program Manipulates Table | Table.Name = <table-name> |
| INSERT |
INSERT INTO <table-name> … |
Program Inserts Into Table | Table.Name = <table-name> |
| SELECT |
SELECT … FROM table-name |
Program Reads Table | Table.Name = <table-name> |
| UPDATE |
UPDATE <table-name> … |
Program Updates Table | Table.Name = <table-name> |