Re: dbschema output

Richard, You can use the options with dbschema to get what you need. There's a "-t" option for tables, so you could "dbschema -d database -t tablename filename", or "-t all" for all tables. Just type dbschema by itself and hit return. This will show you all of the options available with the command. Hope this helps, Tracy > > Hi everyone! > > Apologies in advance if I'm being thick, but I've read the manual, > and it doesn't seem to help. (OK, I'm using OnLine 7.13 and we've > only got v6.00 manuals, but that's another story!). What I want > are the create table statements for all tables in a database, but > without the triggers, procedures, privileges etc. I know I can do > a full dbschema and then edit the file, but it's a bit lengthy!! > > Is there an easier way to do this? (I'm want to get a single file > that I can load into S-Designor to get a "pretty picture" of my > database structure - it's documentation time!!). > > TIA, > > Richard. > -- ========================================================================= = Tracy W. Nedd = = Banctec Inc. - DBA = = Silver Spring, Md = = tracyn@asd.banctec.com = ========================================================================= = ALL RIGHTS RESERVED. = = This posting is copyright and may be used only for the purposes = = of professional study, or the professional exchange of information. = = Use of this posting by any commercial organization for the purposes = = of vilifying another is explicitly prohibited. = =========================================================================