The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

asked 07 May '13, 09:29

Simon's gravatar image

Simon
96449
accept rate: 100%


The indexes are dropped as a consequence of disabling the view.

permanent link

answered 07 May '13, 10:47

Elmi%20Eflov's gravatar image

Elmi Eflov
7811014
accept rate: 31%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186
×15

question asked: 07 May '13, 09:29

question was seen: 754 times

last updated: 10 May '13, 09:11