I am new to SQl server and i had to change the column size from varchar(41) to varchar (255).I realised that in versions 6.5 and below i cannot directly edit the size so i had to create a new table with the varchar(255) and copy the data from the old table to the newone.
My problem is that now all other tables in my database still reference the old table, could any one pls suggest how to alter the foreign keys in all my other tables so that they will reference the new created table.