2 Replies Latest reply: Apr 10, 2013 4:31 AM by David Last-Oracle RSS

    Naming of constraints issue when generating DDL


      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?


      Using SQL Developer