What this different color keys means

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

What this different color keys means

Postby fais » Mon Jun 29, 2009 3:26 pm

What do these different KEY mean?

Key with green/yellow color:

Key with solid green color:

Thanks.
fais
 
Posts: 13
Joined: Tue Feb 10, 2009 8:38 pm

Postby Linda Hawksworth » Mon Jul 06, 2009 1:42 pm

The green and yellow key is a primary key (clustered) and the solid green key is a clustered index. The yellow key is a primary key (nonclustered) and the grey key is a foreign key.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests