Diagrams

sh · January 25th, 2005, 04:28 PM

Hi,

Is there any way of producing diagram from existing tables in the database (sql server 2000)?
If not, is there any way of transfering database diagram to remote DB?

Thanks

bmains · January 26th, 2005, 10:29 AM

Sure, in the diagrams, click new diagram, it asks you for the tables you want to add to the diagram. It will display the tables with relationships in the diagram. You can even change the table view also.

Is this what you mean?

Brian

sh · January 31st, 2005, 05:30 PM

Hi,

Thanks Brian, the wizard did create the tables but no relationship beween the tables...right?

bmains · February 1st, 2005, 08:46 AM

Yes, it can create relationships. Click on the foreign key field, drag it to the primary key field.

sh · February 1st, 2005, 10:55 PM

thanks, I was thinking there might be an easier way of creating them at the time of generating the tables.