|
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). Thanks, |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 10 Feb '16, 12:38
question was seen: 2,018 times
last updated: 11 Feb '16, 10:30
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?
Vlad, AFAIK Brad wants to know whether others would have a need for such a tool, he is in the query tool market, cf. his user page.
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.