If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Altering table how-to

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-02-11, 20:58
DAINOVA DAINOVA is offline
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old 06-03-11, 06:23
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On