Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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?


asked 07 May '13, 09:29

Simon's gravatar image

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
accept rate: 36%

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 07 May '13, 09:29

question was seen: 2,549 times

last updated: 10 May '13, 09:11