Ravindra BagaleCourses & study guides Track your progress

How do you check whether a column is really a unique key?

How do you check whether a column is really a unique key? I compare COUNT(*) with COUNT(DISTINCT key). If the two numbers are equal and the key has no NULLs, every value appears only once.
Download PNG · Open lesson