Hi all, I'm currently playing with some of features in SQL Anywhere 16. I have various tables that I have joined together in a materialized view for the purposes of full text searching some columns from each of the tables. In attempting to add a new column to one of the tables I discovered that not only did I have to disable, enable and refresh the view but it also dropped both my unique and text indexes. Is this just the way it is and I will have to recreate all my indexes every time or is there something else I can do to avoid it? Thanks |
The indexes are dropped as a consequence of disabling the view. So I have to disable the view in order to add the column and disabling the view removes all the indexes? There is no way around this? I can see this being somewhat annoying.
(10 May '13, 09:11)
Simon
|