Hi, everyone.
I wrote a script to create a database on another sql server identical to one that already exists. Pretty much I did a 'script as...' to the clip board for everything and ran that on the target sql server.
(I'm writing a script to create this DB on demand, not simply copy it)
So, even though the foreign keys all went into the tables when they were created, the database diagrams do not show. Is there a way, in code, to 'create' these diagrams from the relationships that already exist on the tables?
I didn't see a 'script as' option for diagrams in the original DB.
Using SQL Server 2005 v 9
Thanks everyone.
I wrote a script to create a database on another sql server identical to one that already exists. Pretty much I did a 'script as...' to the clip board for everything and ran that on the target sql server.
(I'm writing a script to create this DB on demand, not simply copy it)
So, even though the foreign keys all went into the tables when they were created, the database diagrams do not show. Is there a way, in code, to 'create' these diagrams from the relationships that already exist on the tables?
I didn't see a 'script as' option for diagrams in the original DB.
Using SQL Server 2005 v 9
Thanks everyone.