entity relationship diagram

I have VS 2005 and SQL Server 2005 Express installed and I created 4 tables and setup the primary and foreign keys and can view the individual foreign key relationships by right clicking on the foreign key.

Is there a way to view a table relationship diagram (fields with primary and foreign keys), such as Access provides. Does VS 2005 or SQL Server 2005 have that capability?

Thanks

If you right-click on the folder named Database Diagrams, you can create a databse diagram. You can create a diagram here. To view the folder, click the plus sign next to the database that you want to create the diagram for.

Enterprise Manager Database Diagram Wizard

I am creating a Table Diagram via Enterprise Manager and the Database Diagra
m
Wizard.
When I copy and paste into Excel, it creates a first column with the numbers
0,1, and 2. Each of these numbers is next to a column. Are these numbers
indicating keys or indexes or what?
Let me know.
Thanks!Hi
Testing this out it seems that this is some internal code, the first column
always seems to have a 1 all other columns seem to be 0, unless it is the PK
which seems to add two to the value i.e. 3 if it is the first column and 2
if not.
Nullability/Datatype/FKs/Indexes do not seem to effect the value.
John
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:E7F36117-2633-4F45-994F-3234A9843978@.microsoft.com...
>I am creating a Table Diagram via Enterprise Manager and the Database
>Diagram
> Wizard.
> When I copy and paste into Excel, it creates a first column with the
> numbers
> 0,1, and 2. Each of these numbers is next to a column. Are these numbers
> indicating keys or indexes or what?
> Let me know.
> Thanks!

Enterprise Manage Diagram Error

I have sql 2000 developer edition runing on Xp professional. I down loaded
sp4 and installed it without error. I can open the create new diagram window,
select a table to add and when I press OK I get an error 'Invalid Class
String' and then nothing gets
saved.
Any constructinve help is appreciated.
Gary
I have EXACTLY the same problem.
If you find the solution please let me know.
Regards
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Have the same situation. Would appreciate any help. Thanks in advance,
Farid
"Gary" wrote:

> I have sql 2000 developer edition runing on Xp professional. I down loaded
> sp4 and installed it without error. I can open the create new diagram window,
> select a table to add and when I press OK I get an error 'Invalid Class
> String' and then nothing gets
> saved.
> Any constructinve help is appreciated.
>
> Gary
>