September 8, 2005 at 9:42 am
Question... I need to change a basically static table to accomodate a new 'code' that is used in our in-house reporting engine. This table is identified in a Foreign Key Constrainst and unless i add this new row (and the new code) to the column in the table, we cannot import data from another system that contains this new code.
My question really is ... if I add a row to this table to add this new code, do I also have to create or update any VIEWS that select from this table that I'm changing???? Hope I didn't make that too confusing..
September 8, 2005 at 9:57 am
Why would you need to change the views?
Or you adding only a row or a column as well?
Is this row to be hidden in the application?
September 8, 2005 at 10:02 am
That's what I'm asking.. if I add a row to a table that is called by a view.. so I have to also drop and recreate the view????
September 8, 2005 at 10:08 am
No.
September 8, 2005 at 10:11 am
Great. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply