orderno is varchar(64), i need to make it varchar(100)
mID column is computed - based on a formula which includes orderno
i also have a pk which is based on orderno and one other field
i thought i could do this for the pk:
alter table TABLENAME nocheck constraint PKNAME
alter table TABLENAME alter column orderno varchar(100)
alter table TABLENAME check constraint PKNAME
it fails w/the same error i get without tryng to disable the constraint:
Server: Msg 5074, Level 16, State 2, Line 1
The column 'Mid' is dependent on column 'orderno'.
Server: Msg 5074, Level 16, State 1, Line 1
The object 'PKNAME' is dependent on column 'orderno'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE ALTER COLUMN orderno failed because one or more objects access this column.
What is the correct way to disable that constraint so i can increase the column length?
also, how do i get around that computed column?