A. System Catalogs : Standard Catalog Interface : Example of HELP VIEW and HELP Statements
 
Share this page                  
Example of HELP VIEW and HELP Statements
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-jul-2010 10:11:56
Type: system catalog
Version: II9.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