This discussion is archived
2 Replies Latest reply: Apr 10, 2013 2:31 AM by David Last RSS

Naming of constraints issue when generating DDL

xarg-Xrc Explorer
Currently Being Moderated
Hi,

Lot of the constraints in my relationaal model are in the format: <table1 name>_<table2 name>_fkv<version #>

Some table names are fairly long and when you append 2 together in many cases, it goes over 30 characters. This comes up as design rule error when I genreate DDL, and will cause issues when I proceed to create database objects out of it.

Is it possible set a new naming convention such as <table name>fk<versionnumber>? And if so, can it be applied retrospectively to all existing contraints?

Cheers.


Using SQL Developer 3.2.20.09

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points