Modeler Display Tables and Relationships ...
SM_WorkMay 15 2013 — edited May 15 2013Ok, so ... I'm reverse-engineering a section of our DB, so as to draw out the tables and constraints.
(using SQL Dev Version 3.2.20.09.87)
I don't want a logical model, I don't want DDL, I just want a picture ... table-layout with relationship lines.
(a fancier and neater napkin drawing, really)
Ok, so ... I get the table list, I right-click on the "Relational Model" entry and choose "Create Display" ...
And it makes a holy mess of 25 tables. I try to straighten it out. Ugh.
Then I figure, I'll delete the darn thing, and start over manually.
BUT I CANNOT GET RID OF IT.
I thot at one point I had a blank canvas, and started to lay out the the two major branches of those 25 tables ... and then I scroll to another part of the screen ... and there are the darn tables again, AND the views I had also asked it to import ... which have no bearing on laying out the tables.
So then I think, I'll just delete these one-by-one, and I try that and it asks me to verify, do I want this table gone?
And I say, NO ... I do not. I want that table. I just don't want the display any more ... or want said table on the display.
I try in the "Display" section under the relational model to delete THAT "Display[1]" item, but no, every time I say "New Display" there's all the old garbage.
So ... now I am thorougly confused: HOW DO I GET RID OF THE DARN LAYOUT???? While keeping the tables?
What I want is to lay out the tables (because I know intimately how they relate to one another), and then click something, e.g., "Auto-Route"??? ... and have it draw the relation lines, and then I straighten these, and then I am done.
But I cannot figure out what to click. The manual is no help.
All I want is a picture.
I am going to give up and go back to ODBC connector in MS Access, wheren I can just lay out the tables in the relationships window, and I will be done in 10 minutes.
What am I doing wrong?
Thanks for your time.
SM