What is error code 1060 in SQL server?

[jamerober]

Getting Error code 1060 in SQL Server what does it mean and how do I fix it? It popped up while I was changing the schema I can paste the exact error message and SQL if that helps. Looking for common causes and quick diagnostic steps.

 

[danisjohn]

On Microsoft SQL Server, Error 1060 means you’re trying to add a table, index, or constraint that already exists — a duplicate object.
To fix it: check whether the object name exists (use sys.objects or information_schema), rename or drop the duplicate, then retry your schema change.