8. SQL Statements : REGISTER TABLE : Description
 
Share this page                  
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.
Note:  For information on registering IMA tables, see the System Administrator Guide.
Note:  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