Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Wiessrussland
    Posts
    10

    Altering table how-to

    Hi,

    I just trying to understand: if I'm adding new column to existing prod table , what impact it could have and steps I 'll need to follow to make sure to make risk=0.
    If it's just completely new column on isolated table (no PK/FK involved), no breakinge existing relationship, load will come from altered process.

    I think that running this altered DDL is good enough, the rest DBA will take care, like propagading this change into all their bkups/etc...


    Tx
    Trento

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by DAINOVA View Post
    the rest DBA will take care
    that is correct

    in fact, you should let the DBA do the entire project, ~especially~ adding the new column to the production database
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •