Data.DBXCommon.TDBXMetaDataCommands
Delphi
TDBXMetaDataCommands = class
C++
class PASCALIMPLEMENTATION TDBXMetaDataCommands : public System::TObject
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | Data.DBXCommon.pas Data.DBXCommon.hpp |
Data.DBXCommon | Data.DBXCommon |
Description
List of available metadata commands to get metadata.
You can use metadata commands to get database metadata, such as a list of tables in a database. Set the TDBXCommand.CommandType property to TDBXCommandTypes.DBXMetadata and set TDBXCommand.Text to one of the constants in the table to acquire the designated metadata. TDBXCommand.ExecuteQuery returns a TDBXReader to access the metadata.
This table lists the types of metadata you can obtain.
| Constant | Description |
|---|---|
|
GetDatabase |
Set TDBXCommand.Text to 'GetDatabase'. When the command is executed, a TDBXReader instance is returned with a single row of database specific metadata. |
|
GetDataTypes |
Set TDBXCommand.Text to 'GetDataTypes'. When the command is executed, a TDBXReader instance is returned with metadata for the data types supported by the driver. The TDBXDataTypesColumns and TDBXDataTypesIndex classes describe and provide access to this metadata's columns. |
|
GetTables |
Set TDBXCommand.Text to 'GetTables [catalog.[schema.[table]]] [table-types]'. 'table-types' is a space separated list of one or more of the constants in TDBXMetaDataTableTypes. When the command is executed, a TDBXReader instance is returned with metadata for the specified table(s). The TDBXTablesColumns and TDBXTablesIndex classes describe and provide access to this metadata's columns. |
|
GetColumns |
Set TDBXCommand.Text to 'GetColumns [catalog.[schema.[table]]]'. When the command is executed, a TDBXReader instance is returned with metadata for the columns of the specified table(s). The TDBXColumnsColumns and TDBXColumnsIndex classes describe and provide access to this metadata's columns. |
|
GetForeignKeys |
Set TDBXCommand.Text to 'GetForeignKeys [catalog.[schema.[table]]]'. When the command is executed, a TDBXReader instance is returned with metadata for the foreign keys of the specified table(s). The TDBXForeignKeysColumns and TDBXForeignKeysIndex classes describe and provide access to this metadata's columns. |
|
GetForeignKeyColumns |
Set TDBXCommand.Text to 'GetForeignKeyColumns [[[catalog.]schema.]table [foreign-key] [PrimaryKey|ForeignKey]]'[PrimaryKey|ForeignKey]. When the command is executed, a TDBXReader instance is returned with metadata for each column pair in the specified foreign keys of the specified table(s). The TDBXForeignKeyColumnsColumns and TDBXForeignKeyColumnsIndex classes describe and provide access to this metadata's columns. |
|
GetIndexes |
Set TDBXCommand.Text to 'GetIndexes [[[catalog.]schema.]table]'. When the command is executed, a TDBXReader instance is returned with metadata for the indexes of the specified table(s). The TDBXIndexesColumns and TDBXIndexesIndex classes describe and provide access to this metadata's columns. |
|
GetIndexColumns |
Set TDBXCommand.Text to 'GetIndexColumns [[[catalog.]schema.]table [index]]'. When the command is executed, a TDBXReader instance is returned with metadata for the columns in the indexes of the specified table(s). The TDBXIndexColumnsColumns and TDBXIndexColumnsIndex classes describe and provide access to this metadata's columns. |
|
GetPackages |
Set TDBXCommand.Text to 'GetPackages'. When the command is executed, a TDBXReader instance is returned with metadata for the specified package(s). The TDBXPackagesColumns and TDBXPackagesIndex classes describe and provide access to this metadata's columns. |
|
GetProcedures |
Set TDBXCommand.Text to 'GetProcedures [catalog.][schema.][procedure]'. When the command is executed, a TDBXReader instance is returned with metadata for the specified procedure(s). The TDBXProceduresColumns and TDBXProceduresIndex classes describe and provide access to this metadata's columns. |
|
GetProcedureParameters |
Set TDBXCommand.Text to 'GetProcedureParameters [[[catalog.]schema.]procedure]'. When the command is executed, a TDBXReader instance is returned with metadata about the parameters of the specified procedure(s). The TDBXProcedureParametersColumns and TDBXProcedureParametersIndex classes describe and provide access to this metadata's columns. |
|
GetUsers |
Set TDBXCommand.Text to 'GetUsers'. When the command is executed, a TDBXReader instance is returned with metadata for the specified user(s). The TDBXUsersColumns and TDBXUsersIndex classes describe and provide access to this metadata's columns. |
|
GetCatalogs |
Set TDBXCommand.Text to 'GetCatalogs'. When the command is executed, a TDBXReader instance is returned with a list of existing catalogs in the database. The TDBXCatalogsColumns and TDBXCatalogsIndex classes describe and provide access to this metadata's columns. |
|
GetSchemas |
Set TDBXCommand.Text to 'GetSchemas [catalog]'. When the command is executed, a TDBXReader instance is returned with a list of existing schemas in the specified catalog(s). The TDBXSchemasColumns and TDBXSchemasIndex classes describe and provide access to this metadata's columns. |
|
GetProcedureSources |
Set TDBXCommand.Text to 'GetProcedureSources [[[catalog.]schema.]procedure]'. When the command is executed, a TDBXReader instance is returned with source of the specified procedure(s). The TDBXProcedureSourcesColumns and TDBXProcedureSourcesIndex classes describe and provide access to this metadata's columns. |
|
GetPackageSources |
Set TDBXCommand.Text to 'GetPackageSources [[[catalog.]schema.]package]'. When the command is executed, a TDBXReader instance is returned with source of the specified package(s). The TDBXPackageSourcesColumns and TDBXPackageSourcesIndex classes describe and provide access to this metadata's columns. |
|
GetRoles |
Set TDBXCommand.Text to 'GetRoles'. When the command is executed, a TDBXReader instance is returned with a list of existing role(s). The TDBXRolesColumns and TDBXRolesIndex classes describe and provide access to this metadata's columns. |
|
GetReservedWords |
Set TDBXCommand.Text to 'GetReservedWords'. When the command is executed, a TDBXReader instance is returned with a list of reserved words for the database. The TDBXReservedWordsColumns and TDBXReservedWordsIndex classes describe and provide access to this metadata's columns. |
|
GetViews |
Set TDBXCommand.Text to 'GetViews [[[catalog.]schema.]view]'. When the command is executed, a TDBXReader instance is returned with metadata for the view(s) specified. The TDBXViewsColumns and TDBXViewsIndex classes describe and provide access to this metadata's columns. |
|
GetSynonyms |
Set TDBXCommand.Text to 'GetSynonyms [[[catalog.]schema.]synonym]'. When the command is executed, a TDBXReader instance is returned with metadata for the synonym(s) specified. The TDBXSynonymsColumns and TDBXSynonymsIndex classes describe and provide access to this metadata's columns. |
|
GetPackageProcedures |
Set TDBXCommand.Text to 'GetPackageProcedures [[[[[catalog.]schema.]package].procedure] [procedure-type]]'.When the command is executed, a TDBXReader instance is returned with metadata for the specified package procedure(s). The TDBXPackageProceduresColumns and TDBXPackageProceduresIndex classes describe and provide access to this metadata's columns. |
|
GetPackageProcedureParameters |
Set TDBXCommand.Text to 'GetPackageProcedureParameters [[[[catalog.]schema.]package].procedure]'. When the command is executed, a TDBXReader instance is returned with metadata for the parameters of the specified package procedure(s). The TDBXPackageProcedureParametersColumns and TDBXPackageProcedureParametersIndex classes describe and provide access to this metadata's columns. |