can't delete table shapes from an ERD without loosing base tables

J

JRough

I have problem. When I have a duplicate table on my ERD diagram and
go to delete one of them it deletes both of them and even worse it
deletes the base table in "tables and views". I got all those tables
from reverse engineering a SQL database and I don't want them to be
deleted just because I delete a table shape from my diagram. I cannot
figure out what the "options" would be to change it. The options
don't make sense to me:

*Always drop from model
*drop from model only if last occurrence on diagram
*never drop from model
*ask user what to do

I have chosen "never drop from model" but as I said if I happen to
delete a table shape from my ERD then that base table in "tables and
views" is gone forever. I just want to move it to a 2nd page. What
is going on here?

tia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tables dropped from ERD diagram also get dropped from "tables andviews" 1
deleting an object table from diagram drops my underlying table 1
Dealing with a Pivot Table (when I don't want to) 0
Cannot export Visio 2007 ERD to SQL Server database 2
Reverse Engineer Wizard in Visio Professional, can't select tables inlast window 1
Can't edit Entity Relationship shapes or see 'Database' pulldown m 0
Visio 2003 Pro: How to make a database diagram with individual row 0
Database Diagramming just plain doesn't work - What am I doing wro 1

Top