Aler tables in CASCADE Mode

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • qhjghz
    New Member
    • Aug 2007
    • 26

    #1

    Aler tables in CASCADE Mode

    Hi,
    I need to alter a column in a database table from varchar(5) to varchar(11). However, the tables involved are having primary key-foreign key contraints. How do I alter the columns. There is one obvious solution to disable all constraints and then alter the column. But are any ALTER TABLE CASCADE options available in SQL Server 2005 so that the child columns automatically get altered when the parent field is alterd. Please also let me know the syntax if possible.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Please find the syntax of Alter table here and here .

    Comment

    Working...