Hi Guru,

I've been trying to figure out how to export table structure with out data and stored procs on the database. I don't see any option in dbexport in informix that can do that. Is there anyway I can do this other than dbexport?

Database: Informix 9.4
Os: AIX 3.5

Hi,

dbexport is not the right tool, dbschema is the right one:

dbschema -d databasename outfile.sql:
you'll get the schema of all the tables of the named database ( including indexes and constraints ), written the file named outfile.sql

dbschema -d databasename -t tabename outfile.sql:
you'll get the named table schema ( including indexes and constraints ), written the file named outfile.sql

No need to be a guru for this :-)

Eric

Hi Eric,

Thanks for the reply this is a great help for me. Last question, does this cover the stored procedures? Thanks.

Hi again,

supposedly, when using only -d databasename options, procedures and functions are listed. They are not listed if you use -d database name -t tablename.

Eric