I'm curious to know; if your query tool had a feature to search your entire SQL Anywhere database for specific data, would you use it? For example, you wanted to see every table and every row that contained the word "John" (in any column).
I assume that you require the so-called "Full Text Search" feature, but I am afraid that in theory you have to build indexes for all tables that you want to scan.
What is the business requirement for your task? E.g. have you tried to use a 3rd-party index servers that can build indexes for whatever you want?
Oops, I didn't understand his question probably... My fault.
Now I am curious how will a possible implementation look like - a dynamic query builder, or indexes for all tables in the same place 🙂
Volker is right, I'm wondering if there is a need for this type of utility. If there is, I would look into creating it. At the moment, I'm not exactly sure what the implementation would look like. I would need to investigate possible techniques.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.