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> |