Ed, you will need to remove the reference in the computed column before
you can change any component of it. What is happening is that when you
attempt to rename or redefine a source column in any of the tables that
have the computed column, you are attempting to change the computed
column definition in one of the tables and not the others. You will have
to do this table by table, redefining both columns in each table, then
get the names back in sync later.
Albert
Ed Rivkin wrote:
Emmitt,
Thanks either I am missing something or wasn't specific enough.
Opendyear isn't the column I am trying to alter. It is a calculated field
that is in the table with the column that I am trying to alter.
The column I am trying to alter is: emailg text 24 and I want to alter it
to emailg text 34.
Regardless if I rename the other occurrences of emailg and then attempt
to change it in the remaining table OR add a new column such as: New
text 34,
I get the same error messages;
-ERROR- As column OpenDYear is used in another table, its type
cannot be redefined. (2942)
-ERROR- Unable to create/modify table. (2832)
Ed
