IBX.IBExtract.TIBExtract.ExtractObject
Delphi
procedure ExtractObject(ObjectType : TExtractObjectType; ObjectName : String = ''; {do not localize} ExtractTypes : TExtractTypes = []);
C++
void __fastcall ExtractObject(TExtractObjectType ObjectType, System::UnicodeString ObjectName = System::UnicodeString(), TExtractTypes ExtractTypes = TExtractTypes() );
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | IBX.IBExtract.pas IBX.IBExtract.hpp |
IBX.IBExtract | TIBExtract |
Description
Fetches specified metadata from the InterBase server and writes it to the Items property.
Call ExtractObject to fetch metadata from the database specified by the Database property and write it to the Items property.
ObjectType indicates the desired type of metadata. Its meaning is modified by the ObjectName and ExtractTypes parameters, as indicated in the following table:
| Value | Meaning |
|---|---|
|
eoDatabase |
Lists all objects defined on the database. This is the list that would be fetched by calling ExtractObject for each of the other object types in turn (plus the create database command that is supported), with no limits placed by the ObjectName and ExtractTypes parameters. |
|
eoDomain |
Lists all domains. If ExtractTypes includes etTable, this list includes only domains for the table specified by ObjectName. |
|
eoTable |
If ObjectName is an empty string, lists all the tables defined on the server. If ObjectName is nonempty, lists all the columns and types of the table named by ObjectName, plus any information specified by ExtractTypes that pertains to that table. This can include domains (etDomain), indexes (etIndex), foreign key constrains (etForeign), check constrains (etCheck), triggers (etTrigger), user permissions (etGrant), and data (etData). |
|
eoView |
If ObjectName is an empty string, lists the text of all views. Otherwise, lists the text of the view named by the ObjectName parameter. |
|
eoProcedure |
If ObjectName is an empty string, lists all the stored procedures. Otherwise, lists the text of the stored procedure named by the ObjectName parameter. To handle the situation where procedures reference each other, ExtractObject creates dummy procedures of the correct name and then alters these to their correct form. If ExtractTypes includes etAlterProc, only the corrected form is fetched. |
|
eoFunction |
Lists all external functions. If ObjectName is nonempty, the list is filtered to include only those functions that match the specified name. |
|
eoGenerator |
Lists all non-system generators. If ObjectName is nonempty, the list is filtered to include only those generators that match the specified name. |
|
eoException |
Lists all exceptions that the database defines. If ObjectName is nonempty, the list is filtered to include only those exceptions that match the specified name. |
|
eoBLOBFilter |
Lists all blob filters. If ObjectName is nonempty, the list is filtered to include only those filters whose function name matches the specified name. |
|
eoRole |
Lists all roles. If ObjectName is nonempty, the list is filtered to include only those roles whose name matches the specified string. |
|
eoTrigger |
If ExtractTypes includes etTable, lists all triggers defined for the table specified by ObjectName. Otherwise, lists all triggers or, if ObjectName is nonempty, all triggers that match the string specified by ObjectName. |
|
eoForeign |
If ExtractTypes includes etTable, lists all foreign key constraints that pertain to the table specified by ObjectName. Otherwise, lists all foreign key constraints, or, if ObjectName is nonempty, all foreign key constraints that have a name that matches ObjectName. |
|
eoIndexes |
If ExtractTypes includes etTable, lists all indexes defined on the table specified by ObjectName. Otherwise, lists all indexes, or, if ObjectName is nonempty, all indexes that have a name that matches ObjectName. |
|
eoChecks |
If ExtractTypes includes etTable, lists all non-foreign check constraints on the table specified by ObjectName. Otherwise, lists all non-foreign check constraints, or, if ObjectName is nonempty, all check constraints that have a name that matches ObjectName. |
|
eoData |
Lists all the data in the object named by the ObjectName parameter. |
ObjectName specifies the name of an object (such as a table or stored procedure) about which you want information. The type of this object and the way it limits the fetched information depends on the values of ObjectType and ExtractTypes.
ExtractTypes modifies the interpretation of ObjectType to filter the type of information fetched.