Data.SqlExpr.TSQLSchemaInfo.Pattern
| [–] Properties | |
|---|---|
| Type: field | |
| Visibility: public | |
| Source: Data.SqlExpr.pas Data.SqlExpr.hpp
| |
| Unit: Data.SqlExpr | |
| Parent: TSQLSchemaInfo | |
Delphi
Pattern: string;
C++
System::UnicodeString Pattern;
Description
Represents an SQL pattern mask that filters the resulting dataset.
Pattern uses the wildcards '%' (to match a string of arbitrary characters of any length) and '_' (to match a single arbitrary character). To use a literal percent or underscore in a pattern, the character is doubled (%% or __). If you do not want to use a pattern, set Pattern to nil (Delphi) or NULL (C++). The name of each item (table, stored procedure, field, parameter, or index) must match this pattern mask. If not, it does not appear as a record when the SQL dataset is opened.