You must consider naming limitations when creating and modifying data used by the software. Naming limitations include restrictions on the length and content of names, such as database table, view, and column names. These restrictions also affect reference data names.
Both SQL Server and Oracle use keywords and future keywords. Check the SQL Server or Oracle documentation before you choose names for your metadata objects so that the names you choose do not clash with SQL or Oracle keywords.
The following table shows the name length limitations in the reference data.
Name |
Maximum for SQL Server |
Maximum for Oracle |
Codelist name |
254 characters |
210 characters |
Codelist long or short description |
255 characters |
255 characters |
Property name |
28 characters |
28 characters |
Interface name |
121 characters |
31 characters |
Part class name (sheet name) |
31 characters |
23 characters |
Piping commodity name |
249 characters |
249 characters |
-
Do not use special characters in names. Special characters include: | . - ! ? + ' % , ; & ~ * < >
See Also