In This Chapter

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

In This Chapter

This chapter describes the dbschema utility and how to use it. You can use dbschema with the following database servers:

Dynamic Server 10.0, 9.40, 9.30, 9.2x, 7.3x or 7.24
Dynamic Server, Linux Edition 7.3x
Workgroup Edition 7.3x or 7.24
SE
OnLine 5.1x

The dbschema utility prints the SQL statements that are necessary to replicate a specified table, view, or database. It also shows the distributions that the UPDATE STATISTICS statement creates.

You can use the dbschema utility for the following purposes:

To display the SQL statements (the schema) that are required to replicate a database or a specific table, view, synonym, sequence, or procedure
To display the schema for the Information Schema views
To display the distribution information that is stored for one or more tables in the database
To display information on user-defined data types and row types

Caution:

Use of the dbschema utility can increment sequence objects in the database, creating gaps in the generated numbers that might not be expected in applications that require serialized integers.