In an SQL Server Database Diagram what does the little key mean besides a table?

In an SQL Server Database Diagram what does the little key mean besides a table?
Mr_ShawAsked:
Who is Participating?
 
David L. HansenProgrammer AnalystCommented:
It means that the field in question is the Primary Key.  Do a google search if you want.  Basically, a primary key is used to uniquely identify each row (like Social Security Number would be a good Primary key for a people table).
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
that indicate the foreign key relation ship, (ususally will be related to the column with the Key in that table )
0
 
dqmqCommented:
A key symbol next to a column indicates that column is part of the primary key.

A key next to a relationship line indentifies the parent table in the relationship. The child table is identified by an infintity sign.  Think of it as the "many" side of a one-to-many relationship.
0
 
Mr_ShawAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.