I Have table Emp contains 3 columns one column is EName that datatype is char. now I want to change char to Varchar(4) . but column is primary key . and it is refernced by othertable columns . i write query alter table emp alter column ename varchar(4) but it throws an error is Msg 5074, Level 16, State 1, Line 1 The object 'PK_emp is dependent on column 'Ename'. Msg 4922, Level 16, State 9, Line 1 ALTER TABLE ALTER COLUMN ename failed because one or more objects access this column. please help me asap. Regards Swamy |