Re: dbschema

[Devesh Patel]

Hi Bob,
Informix DBSCHEMA utility will provide you database schema.
It is very simple to use
dbschema -d <databasename> <outputfile name>

For example you want to see all tables definations in 'stores' database

dbschema -d stores

If you want to capture all tables definations in 'stores' database in 'stores.sql' file:

dbschema -d stores ./stores.sql

for more information on dbschema and other informix utilities please refer to IBM website: http://www-306.ibm.com/software/data/informix/

They also have online manuals on their web site.

Hope this helps.

Devesh Patel, Senior Consultant
MySQL Inc.
Get More with MySQL! http://www.mysql.com/consulting