Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Database design issues : Naming conventions : Table names
Table names
There can be more than one Oracle table (or view) with the same name within a database, because Oracle qualifies tables by owner as well as by name. OpenEdge requires unique table names.
OpenEdge resolves nonunique table names for you. When OpenEdge encounters matching table names while creating or updating a schema image, for the second and subsequent occurrence of a table name, it names the corresponding Oracle table table-1, table-2, etc. For example, if OpenEdge encounters a second instance of a table named employee in the Oracle database, it names the corresponding schema-holder table employee-1. The Table Properties Sheet in the Data Dictionary shows you which Oracle table maps to the schema holder table.