Example of HELP VIEW and HELP Statements
Note: HELP commands are valid in interactive SQL but not in the Query Editor.
The following HELP VIEW statement displays information about the iisynonyms view:
help view iisynonyms
Example output:
View: iisynonyms
Owner: $ingres
Check option: off
View Definition:
create view iisynonyms(
synonym_name,
synonym_owner,
table_name,
table_owner)
as
select synonym_name,
synonym_owner,
relid,
relowner
from "$ingres".iirelation,
"$ingres".iisynonym
where reltid = syntabbase
and reltidx = syntabidx
The following HELP statement displays the format of the iisynonyms catalog:
help iisynonyms
Example output:
Name: iisynonyms
Owner: $ingres
Created: 17-mar-2019 11:53:42
Type: system catalog
Version: II10.0
Column Information:
Key
Column Name Type Length Nulls Defaults Seq
synonym_name char 256 no no
synonym_owner char 32 no no
table_name char 256 no yes
table_owner char 32 no yes
Last modified date: 10/30/2024