Kbase 17727: How to change a table or field name in Roundtable.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to change a table or field name in Roundtable.
To rename a field, you change the "Local Field Name" field. See "Field
Assignments" in chapter 6 of the Roundtable User's Guide. This changes
the name of the field in the table, but it does _not_ change the
name of the PFIELD object. The PFIELD object name remains the same.
(You can't change an object name in Roundtable, because everything
is keyed on object name).
When you run Load Schema, and there are field name changes, it only
changes the local field name. See "Load Schema" in chapter 7 of the
User's Guide. There are a few paragraphs in that section that deal
with exactly this.
Table renames work similar to field renames.
Some people don't like that the PFIELD object name does not change,
even though the field name did. It's a little confusing that they
don't match. You can delete the old PFIELD and add a new PFIELD with
the correct name. Remember though that this will cause the old field
to be deleted and then a new one to be added. Any data in the old
field will be lost for any database that you apply this change to,
including "downstream" workspaces (test, pre-production, production)
and any customer sites that you deploy this change out to.
2/25/98 J.Green
Entered by FS
Progress Software Technical Support Note # 17727