Re: Structure of a table

Jeff Lanham wrote: > > Yes there is: > > dbschema -d database-name -t table-name >filename.sql> > Now you have an sql file with the create statement for that table. > You may have to edit the file and delete the first few lines. I hate to point out the obvious, but if you use the full syntax for placing the results in a file, then you won't need to delete the first few lines. :-) dbschema -d database_name -t table_name script_name.sql Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+