IBM 000-8697 Manual Do Utilizador

Utilities

All

SERIAL

 fields included in

CREATE TABLE

 statements displayed by

 have a starting value of 1, regardless of their original starting

value.

The dbschema utility uses the owner.object convention when it generates any

CREATE TABLE

,

CREATE INDEX

,

CREATE SYNONYM

,

CREATE VIEW

,

CREATE

PROCEDURE

, or

GRANT

 statements, and when it reproduces any unique or

referential constraints. As a result, if you use the dbschema output to create
a new object (table, index, view, procedure, constraint, or synonym), the new
object is owned by the owner of the original object. If you want to change the
owner of the new object, you must edit the dbschema output before you run
it as an

SQL

 script.

For more information about the

CREATE TABLE

,

CREATE INDEX

,

CREATE

SYNONYM, CREATE PROCEDURE, GRANT

, and

CREATE VIEW

statements, see

eference.

If you specify

all

for ownername, dbschema displays all

CREATE SYNONYM

statements for the database, table, or view specified.

Output from dbschema that is executed with the specified option

-s alice

might appear as follows:

CREATE SYNONYM "alice".cust FOR "alice".customer

For more information about the

CREATE SYNONYM

statement, see

eference.

directs dbschema to display

the CREATE SYNONYM

statements

owned by ownername.

Synonyms

-s ownername