Relačná algebra
HELP SQL – Prints a list of SQL topics for which help is available.
HELP TABLE tablename {,tablename} – Prints detailed information about
the specified table(s).
HELP VIEW viewname {,viewname} – Prints description of the specified view(s). (Specific Gateways may not support view information.)
HELP is available on the following SQL topics:
Príkazy SQL :
ALTER GROUP DIRECT CONNECT MESSAGE
ALTER ROLE DIRECT DISCONNECT MODIFY
COMMIT DIRECT EXECUTE RAISE ERROR
COPY DROP RAISE DBEVENT
CREATE DBEVENT DROP DBEVENT REGISTER
CREATE GROUP DROP GROUP REGISTER DBEVENT
CREATE INDEX DROP INTEGRITY REMOVE
CREATE INTEGRITY DROP LINK REMOVE DBEVENT
CREATE LINK DROP PERMIT REVOKE
CREATE PROCEDURE DROP PROCEDURE ROLLBACK
CREATE ROLE DROP ROLE SAVE
CREATE RULE DROP RULE SAVEPOINT
CREATE TABLE GRANT SELECT
CREATE VIEW HELP SET
DECLARE INSERT UPDATE
DELETE
‚datatypes‘ ‚set_functions‘ ‚type_functions‘
‚numeric_functions‘ ‚string_functions‘
Quotation marks required as shown.
Type: HELP topic
‚HELP help‘ lists all HELP options/descriptions.
Terminate all statements with a semicolon.
Some of the INGRES commands listed above are not supported by Open SQL. Open SQL is a subset of INGRES SQL that is supported by all Gateways. Gateways are interfaces between INGRES applications and non-INGRES databases.HELP on each individual topic will indicate if an INGRES command is not supported by Open SQL.
