Re: Dbschema

paul.d.finkel (pfinkel@cbnews.cb.att.com) wrote: > I am using dbschema to duplicate a database structure in a newly created > instance of OnLine 7.1. I have used dbschema before, yet I still have > questions based on a recent experience: > 1) If I use dbschema to create a schema file, from a working database, > why would the use of the schema file in creating a new database > structure generate an error (#201 - Synatx error)? > 2) When I run the schema SQL commands from within the isql interface > and reach the error, I escape to my editor . At that point I remove > all of the statements ABOVE and including the offending statement > assuming that ONLY those satements have run. > When I re-run what I have left, if > the first statement is a "CREATE TABLE ..." statement, I get a new > error message: table already created. How could that table have been > created,if the running of the schema file bombed out at the > statement above? Try using dbaccess to re-load the schema. If the database you're trying to duplicate contains triggers or Stored Procedures, ISQL will return syntax error!! klb