Adding to the end. No keys, only indexes.
Dick
On 1/5/2016 1:45 PM, Albert wrote:
Are you adding them to the end of the table or trying to insert
columns? Moving a column by inserting sometimes causes these sort of
upsets.
Are there any foreign keys to the table? That might the index reference.
Albert
On 2016-01-05 12:38 PM, Carpet Broker, Dick Fey wrote:
I am trying to add a couple of columns to an existing table that has
computed and indexed columns. It would appear
I have to change those to no compute and no index to do so. Is that
the only way ?
The additions have no bearing on the computed or indexed columns.
--
Dick Fey
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138