Syntax:
CREATE statements for all objects of the database catalog that the current user has defined are written to the file specified after OUTFILE (* as the filename is not allowed).
GRANT statements are written into the command file for the privileges the current user has granted for these objects to other users.
The generated command file contains the following statements:
- CREATE TABLE for the user's base tables,
- CREATE SYNONYM for the table name synonyms the user has defined,
- GRANT for all privileges the user has granted to other users,
- CREATE INDEX for the indexes defined for all the tables of the user,
- ALTER TABLE ... FOREIGN KEY for the link definitions referring to all tables of the current user,
- CREATE VIEW for the user's view tables,
- COMMENT ON for the comments the user has defined for the tables, columns, indexes and domains,
- CREATE DOMAIN for the user's domains.
The generated command file contains one statement that should be handled in a special way. The command file should therefore be executed with CATALOGLOAD USER.