Remove constraint and table name version details in sql developer data model

489 views Asked by At

I have problem with Table and Constraint name ,which are coming with version in Model Diagram representation.Using Oracle SQL Developer Data Modle shows my table name as APP_REALm_ENTRIESv4,but my table name used in create statement is APP_REALm_ENTRIES .Table name comes with extra characters v4.Because that no of time I have re-created table is four.Same problem persists with contraints too like ARE_ID_PK added with v4.

enter image description here

1

There are 1 answers

0
Markus On

When the modeler adds "v1" or "v2" or .. on your table name your chosen table name is already defined in your model and your edited table should get the same name. To avoid that conflict the modeler adds "v1".