Objects in SQL should normally have unique names. SQLEditor will attempt to prevent you from creating two objects that have the same name.
Typically this happens as you add new objects or edit the names of existing objects. The name will change as soon as the object is redrawn.
For example, if there are one table in the document, Table1
A new table is added. It will automatically be given the name Table1_1
