Post reply

Is 'on update cascade' include column name changing?

  • October 17, 2007 at 3:05 am

    #178543

    Hello,

    I'm using the exec sp_rename statmente as follows:

    exec sp_rename 'table.old_column_name','new_column_name','column'

    and I wondered if its my responsibilty to chang also all columns name in the childrens table

    Thanks

    Rachamim

  • October 17, 2007 at 3:21 am

    #742622

    Rachamim

    Strictly speaking, it's not necessary to change the name of the column in the child table. But you will need to drop any foreign key constraints and recreate them so that they reference the column in the parent table by its new name.

    John

  • October 17, 2007 at 6:45 am

    #742692

    Thank you Jhon ,it was very helpful 🙂

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

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