Register Table Description
The register table statement maps the fields in a file to columns in a virtual table. After registering the file as a table, use SQL to manipulate the contents of the file. The registered table can be referred to in database procedures. To delete a registration, use the
remove table statement (see
Remove Table Statement).
Note: Notes:
• For information about registering IMA tables, see the Ingres System Administrator Guide.
• This statement is not the same as the register...as link statement, which is described in the Ingres Star User Guide.
The following statements can be performed against registered tables:
• create view
• create synonym
• create rule
• comment
• select
• insert, update, and delete (if they are from an updatable Enterprise Access product)
• drop
• save
• register...as link (as described in the Ingres Star User Guide)
The following statements cannot be performed against registered tables:
• modify
• create index