TextSearch

TextSearch Function

Searches all the specified tables for the specified string value. This is an exhaustive search and may take a long time.

Syntax

TextSearch(connection Conn, scalar Table, scalar SearchValue)

Arguments

Argument	Description
connection Conn	Data connection
scalar Table	Table names from the connection
scalar SearchValue	Value to search for

Examples:

TextSearch($MyConn$, ".*", "abc")

Searches for string "abc" in all tables in "MyConn" connection. Returns the list of all tables and columns in the connection "MyConn" which contain "abc".