Subject | Globa Fieldnamel Renaming |
---|---|
Author | Hans Hoogstraat |
Post date | 2003-11-02T17:40:41Z |
Would it be feasable to expect a global field rename.
The alter Table FieldName to FieldNewName works great, as
long the FieldName isn't used in some dependency.
The only way I found to global rename a fieldname is by exporting
the Metadata , global change the FieldName to NewFieldName
in the exported Metadata Sql file, then build a new Database using
the edited Metadata and using some Pump mechanism to copy
the data from the old database to the new one. All generators
will be incorrect.
Is there a better way, A global field rename sure would be easy
when planning a new database :)
Best Regards,
Hans
The alter Table FieldName to FieldNewName works great, as
long the FieldName isn't used in some dependency.
The only way I found to global rename a fieldname is by exporting
the Metadata , global change the FieldName to NewFieldName
in the exported Metadata Sql file, then build a new Database using
the edited Metadata and using some Pump mechanism to copy
the data from the old database to the new one. All generators
will be incorrect.
Is there a better way, A global field rename sure would be easy
when planning a new database :)
Best Regards,
Hans