-
标题
ApexSQL Search - Text search -
解决办法
Applies to ApexSQL Search Summary This article describes the benefits of using the Text search feature.Description
The Text search feature allows to find data in SQL tables and views matching the phrase is specified, including data stored in encrypted views or databases encrypted with Transparent Data Encryption (TDE).
Quick tip:
The Text search feature doesn’t support searching for data stored in system objects
Quick tip:
The minimum permissions required to use the Text search feature are:- Public role membership on the searched SQL instance,
- Connect and
- View definition on the searched database
- Select on the searched database
- View any definition has to be granted on the searched SQL instance
Quick tip:
For more information on the search phrases and wildcards visit the See also section
The search scope can be controlled by:
- Selecting the exact objects and columns that need to be searched in the Select objects to search list
Quick tip:
To quickly select just specific objects or columns, click Uncheck all in the Select objects to search list context menu and then select only the ones to be searched
- Specifying whether to match:
- Numeric columns
- Text type columns
- Unique identifier columns
- Date columns
- Selecting the Views option to include both tables and views in the search
Quick tip:
To quickly remove duplicate data from the search results (e.g. to find out whether the data exists, not its exact location), deselect the Views option
- Specifying whether to display exact matches only. For instance, if the Exact match option is selected, results containing 11 won’t be displayed if 1 is searched for
See also
ApexSQL Search - Search phrases, history and results ApexSQL Search - Object search ApexSQL Search - Safe renameLast updated
November 20, 2014
