Found my answer by finding the conflict index using

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME LIKE '%PK_TABLE1%'

and removed the key then change the collation of the database.

The problem is I can't find where the said index.

Great question and that explanation is always a must for every QotD.