Now I have to modify a number of foreign key to include this. I tried the ALTER COLUMN, MODIFY, but they didn' t work. I' m thinking of saving the data in the tables, droping the tables and create them again the right way. I' m not going to do this unless there won' t be other options.
Do you have any other ideas.