Rank: Newbie
Joined: 4/8/2009
Posts: 1
Location: Fayetteville, AR
|
So far I'm loving the product, I had a question though about being able to generate the creation script via the Show in new SQL Editor command. Basically I'm selecting multiple tables and right clicking on them, selecting 'Show in new SQL Editor' and then selecting 'Create'
This gives me the sql to create all my tables. From what I can tell though, the CONSTRAINT commands are included within each table... although this is technically correct, I can't use this script to recreate my database because certain constraints reference tables that haven't been created yet. There are 2 possible solutions here:
1. Make sure that the order of table creation is done in a manner where the tables that are need have already been created. (Not even sure if that is possible).
2. Don't include the constraint information in the Create statement.. rather, after all the tables have been created, ALTER the tables to include the constraint.
Of course, I could be missing something in the app that already does this and if so, please point me the way. Thanks,
Thomas
|
Rank: Advanced Member
Joined: 5/16/2009
Posts: 82
|
Hi twynne,
I just took a try and I found out that it's important the *order* in which you select the table before you call 'Show in new SQL Editor->Create'.
Take a try: if you select first the parent table and then the child then you have a working script.
Cheers!
|
