Visual indicator of Alternate Key columns (unique index) in query designer
It is a common database design practice to use a single-column surrogate key as the Primary Key in each table, but also within the same table have the presence of "Natural Key" (or "Alternate Key") columns that also have a unique index assigned to them, for example:
-- StudentCourse --
StudentCourseID (PK)
StudentID (AK)
CourseID (AK)
--Indexes--
PK_StudentCourse (StudentCourseID)
AK_StudentCourse (StudentID, CourseID)
So, using this example, in the query designer it would be useful to have a visual indicator that there is a unique index on columns StudentID & CourseID (just as there is a visual indicator that StudentCourseID is the Primary Key).
-- StudentCourse --
StudentCourseID (PK)
StudentID (AK)
CourseID (AK)
--Indexes--
PK_StudentCourse (StudentCourseID)
AK_StudentCourse (StudentID, CourseID)
So, using this example, in the query designer it would be useful to have a visual indicator that there is a unique index on columns StudentID & CourseID (just as there is a visual indicator that StudentCourseID is the Primary Key).