Syntax of the dbschema Command

Home | Previous Page | Next Page Data Migration Utilities > The dbschema Utility >

Syntax of the dbschema Command

>>-dbschema----------------------------------------------------->
 
                                                                                    (1)
>--+-+-------------------+--| Database Options |--+-------------------+--+-| UDTs |----------+-+-><
   | '-| Table Options |-'                        '- -R--+----------+-'  '-+- -u--+--+-----+-' |
   |                                                     '-filename-'      '- -ui-'  '-all-'   |
   '- -V---------------------------------------------------------------------------------------'
 
Table Options:
 
|--+-+-------------------+--+---------------------+--+---------------------------------------+-+-->
   | |              (2)  |  |                (3)  |  |                                  (4)  | |
   | '-| Synonyms |------'  '-| Privileges |------'  '-| Tables, Views, or Procedures |------' |
   '- -hd--+-all-----------------+-------------------------------------------------------------'
           |                (5)  |
           '-| Table Name |------'
 
>--+----------------+-------------------------------------------|
   |           (6)  |
   '-| Roles |------'
 
Database Options:
 
|--+------+--+---------------------+--+-----+-- -d--database---->
   '- -ss-'  '- -seq--+-sequence-+-'  '- -x-'
                      '-all------'
 
>--+-----+------------------------------------------------------|
   '- -n-'

Notes:

See page User-Defined and Complex Data Types (IDS 9.x or Later)
See page Synonym Creation
See page Privileges
See page Table, View, or Procedure Creation
See IBM Informix Guide to SQL: Syntax
See page Role Creation

Element	Purpose	Additional Information
all	Directs dbschema to include all the tables or sequence objects in the database, or all the user-defined data types in the display of distributions	None.
-d database	Specifies the database or co-server to which the schema applies. The database can be on a remote database server.	References: If you want to qualify the name of the database, see the "Database Name" section of the IBM Informix: Guide to SQL Syntax.
filename	Specifies the filename to contain the dbschema output	If you omit filename, dbschema sends output to the screen. If you specify a filename, dbschema creates a file named filename to contain the dbschema output.
-hd	Displays the distribution as data values	References: For more information, see Distribution Information for Tables.
-it	Displays the isolation type.	None.
-l	Displays the lock level.	None.
-seq sequence	Generates the DDL statement to define the specified sequence object	References: For more information, see Sequence Creation.
-ss	Generates server-specific information	Restrictions: This option is ignored if no table schema is generated. References: For more information, see Server-Specific Information.
-u	Prints the definitions of functions, casts, and user-defined data types	References: For more information, see User-Defined and Complex Data Types (IDS 9.x or Later).
-ui	Prints the definitions of user-defined data types, including type inheritance	References: For more information, see User-Defined and Complex Data Types (IDS 9.x or Later).
-V	Displays product version information	None.
-x	Expands dbslice names into dbspace name lists in -ss output	If the dbspace contains multiple partitions, dbspace partition names appear in the output.

You must be the DBA or have the Connect or Resource privilege for the database before you can run dbschema on it.