The above will return to you all column_name values along with the number of their occurrence.If the number of occurrence is higher than one (1), then they are not unique.SELECT [column_name],
COUNT(*)
FROM [owner].[table_name]
GROUP BY [column_name]
HAVING COUNT(*) > 1;
If the result of this query is empty, then you have unique values in this column.