Subject | Altering column types |
---|---|
Author | Rick Debay |
Post date | 2005-09-29T21:53:34Z |
I'm trying to change a column type from char(1) to a domain that is
char(1), and a column that is Numeric(11,0) to Varchar(19). In both
cases, all data in the column will fit in the destination type.
In both cases, I get the error that another something (constraint,
index, stored procedure, trigger) has a dependancy on the column so its
type can't be changed.
Is there anything that can be done besides changing every item to not
reference the column, change it, and then add all the references back?
Secondly the domain in the char(1) change has no character-set type, nor
does the column. Yet when I try to make the change, it complains that I
can't change the character set.
Thanks, Rick DeBay
char(1), and a column that is Numeric(11,0) to Varchar(19). In both
cases, all data in the column will fit in the destination type.
In both cases, I get the error that another something (constraint,
index, stored procedure, trigger) has a dependancy on the column so its
type can't be changed.
Is there anything that can be done besides changing every item to not
reference the column, change it, and then add all the references back?
Secondly the domain in the char(1) change has no character-set type, nor
does the column. Yet when I try to make the change, it complains that I
can't change the character set.
Thanks, Rick DeBay