var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need a dump of database tables and stored proc
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
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 :-)
Thanks for the reply this is a great help for me. Last question, does this cover the stored procedures? Thanks.
supposedly, when using only -d databasename options, procedures and functions are listed. They are not listed if you use -d database name -t tablename.