Post reply

Change column type

  • March 13, 2008 at 5:24 pm

    #188034

    I want to extend the length of a primary key column. There are about 20 tables with foreign keys that reference this column.

    Whats the best way to do this?

    I would need to change all the foreign key columns too to the same size right?

  • March 13, 2008 at 8:04 pm

    #789405

    Disable the constraints;

    Change their data types;

    Enable the constraints.

  • March 13, 2008 at 8:28 pm

    #789413

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply