Re: NEED HELP W/ INFORMIX

George Teachman wrote >Getting a schema is as easy as the following. >dbschema -d database -t all schema.sql >Replace database with the name of the database, minus the '.dbs' >extension. >schema.sql is the name of the file that you wish to put the schema >in. >all means all the tables. >There is a caveat though. dbschema won't spit out any of the >of the access permissions. Or, it won't spit them all out. Anyway, >you won't get an exact picture of the database, indices, permissions, > etc. I don't agree. If you include -p all in your command line, the file will contain all the access permissions for the database. ** Opinions expressed are my own and not necessarily those of my employer ========================================================================= Barry Toomey Phone +353-1-2822333 AT&T Network Systems Ireland Fax +353-1-2822864 Corke Abbey Avenue, email: bt@irl3b2c.att.comm Bray, uunet: att!irl3b2c!bt Co. Dublin Ireland =========================================================================