Subject | Change field type to domain |
---|---|
Author | Rick Roen |
Post date | 2006-01-19T13:56:59Z |
FB1.5
I want to change certain field types in existing tables to be a
Domain. The Domain is the same type as the field type now, i.e.
NUMERIC(18,3) existing and I want to use a Domain that is defined as
NUMERIC(18,3).
When I try to alter the table (using DBWorkbench) I get "error
335544351 Unsucessful metadata update Column ? in table ? is
referenced in ...procedures".
Is there some way to change the field type to the Domain without
having to drop and recreate the referenced procedures?
Rick
I want to change certain field types in existing tables to be a
Domain. The Domain is the same type as the field type now, i.e.
NUMERIC(18,3) existing and I want to use a Domain that is defined as
NUMERIC(18,3).
When I try to alter the table (using DBWorkbench) I get "error
335544351 Unsucessful metadata update Column ? in table ? is
referenced in ...procedures".
Is there some way to change the field type to the Domain without
having to drop and recreate the referenced procedures?
Rick