Text Filter

DBA xPress ›› Features ›› Object Browser ›› Match Elements ››
Parent Previous Next

Text Filter


The text filter has four options, these are 'Source', 'Mode', 'Text' and 'Case sensitive match'. The 'Text' is simply the text that you want to search for, and the 'Case sensitive match' specifies whether the text searched for matches the case of the entered text or not.

 

The 'Source' specifies where to look for the specified text 

Source

Description

Object definition

This specifies that the object's definition is the place where the text is searched for. Note that definition applies to any object which is SQL programmable (i.e. views, procedures, functions, triggers).

Object name

This specifies that the object's name is the place where the text is searched for.

Object name or parent object name

This specifies that the object's name, as well as the parent object's name, are the places where the text is searched for.

Object or parent definition

This specifies that the object's definition, as well as the parent object's definition, are the places where the text is searched for. Note that definition applies to any object which is SQL programmable (i.e. views, procedures, functions, triggers).

Object owner name

This specifies that the name of the object's owner (i.e. database principal) is the place where the text is searched for. Note that under SQL Server 2000, the object's owner is the same as the object's schema.

Object schema name

This specifies that the name of the object's schema is the place where the text is searched for.

Parent object definition

This specifies that the parent object's definition is the place where the text is searched for. Note that definition applies to any object which is SQL programmable (i.e. views, procedures, functions, triggers).

Parent object name

This specifies that the parent object's name is the place where the text is searched for.

 

The 'Mode' specifies how to look to match the specified text with the selected text from the object 

Mode

Description

begins with

This specifies that the source text must begin with the specified match text.

contains

This specifies that the source text must contain the specified match text.

does not begin with

This specifies that the source text must not begin with the specified match text.

does not contain

This specifies that the source text must not contain the specified match text.

does not end with

This specifies that the source text must not end with the specified match text.

does not match regular expression

This specifies that the source text must not match the regular expression that is specified by the match text. Note that the regular expression must conform to the standard Microsoft .NET regular expression format.

ends with

This specifies that the source text must end with the specified match text.

is

This specifies that the source text must be exactly the same as the specified match text.

is not

This specifies that the source text must not be exactly the same as the specified match text.

matches regular expression

This specifies that the source text must match the regular expression that is specified by the match text. Note that the regular expression must conform to the standard Microsoft .NET regular expression format.