FireDAC.Comp.Client.TFDCustomManager.GetSchemaNames
Delphi
procedure GetSchemaNames(const AConnectionName, ACatalogName, APattern: string;
AList: TStrings);
C++
void __fastcall GetSchemaNames(const System::UnicodeString AConnectionName, const System::UnicodeString ACatalogName, const System::UnicodeString APattern, System::Classes::TStrings* AList);
Contents
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDCustomManager |
Description
Populates a string list with the names of schemas in a DB.
Call GetSchemaNames to retrieve a list of schemas from a DB.
AConnectionName is the connection name to use.
ACatalogName restricts schema names to the specified catalog. If this is empty, all schemas are returned.
APattern is the LIKE-pattern for filtering schema names.
AList is a TStrings descendant that receives the schema names. Any existing strings are deleted from the list before GetSchemaNames adds the names of all the schemas in a DB.
Example
FDManager.GetSchemaNames('myconn', '', '', ListBox1.Items);