Question

How can I check a column in a database to see if it contains unique data.

Answer 1

Here is one way to check.  In this case, if the following query returns any results, we know that the medicationDescription contains duplicates

SELECT medicationDescription, COUNT(medicationDescription) FROM Meds GROUP BY medicationDescription HAVING COUNT(medicationDescription) > 1