Public Member Functions | |
Boolean | AllProceduresAreCallable () |
Can all the procedures returned by getProcedures be called by the current user? | |
Boolean | AllTablesAreSelectable () |
Can all the tables returned by getTable be SELECTed by the current user? | |
ClearCache (const string Key) | |
Clears specific cached metadata. | |
ClearCache () | |
Clears all cached metadata. | |
Boolean | DataDefinitionCausesTransactionCommit () |
Does a data definition statement within a transaction force the transaction to commit? | |
Boolean | DataDefinitionIgnoredInTransactions () |
Is a data definition statement within a transaction ignored? | |
Boolean | DoesMaxRowSizeIncludeBlobs () |
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs? | |
IZResultSet | GetBestRowIdentifier (const string Catalog, const string Schema, const string Table, Integer Scope, Boolean Nullable) |
Gets a description of a table's optimal set of columns that uniquely identifies a row. | |
string | GetBestRowIdentifierCacheKey (const string Catalog, const string Schema, const string Table, const Integer Scope, const Boolean Nullable) |
returns cache key for GetBestRowIdentifier metadata entry | |
GetCacheKeys (TStrings List) | |
fills string list with the keys for the currently cached metadata entries | |
IZResultSet | GetCatalogs () |
Gets the catalog names available in this database. | |
string | GetCatalogsCacheKey () |
returns cache key for GetCatalogs metadata entry | |
string | GetCatalogSeparator () |
What's the separator between catalog and table name? | |
string | GetCatalogTerm () |
What's the database vendor's preferred term for "catalog"? | |
IZResultSet | GetColumnPrivileges (const string Catalog, const string Schema, const string Table, const string ColumnNamePattern) |
Gets a description of the access rights for a table's columns. | |
string | GetColumnPrivilegesCacheKey (const string Catalog, const string Schema, const string Table, const string ColumnNamePattern) |
returns cache key for GetColumnPrivileges metadata entry | |
IZResultSet | GetColumns (const string Catalog, const string SchemaPattern, const string TableNamePattern, const string ColumnNamePattern) |
Gets a description of table columns available in the specified catalog. | |
string | GetColumnsCacheKey (const string Catalog, const string SchemaPattern, const string TableNamePattern, const string ColumnNamePattern) |
returns cache key for GetColumns metadata entry | |
IZConnection | GetConnection () |
Retrieves the connection that produced this metadata object. | |
IZResultSet | GetCrossReference (const string PrimaryCatalog, const string PrimarySchema, const string PrimaryTable, const string ForeignCatalog, const string ForeignSchema, const string ForeignTable) |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key. | |
string | GetCrossReferenceCacheKey (const string PrimaryCatalog, const string PrimarySchema, const string PrimaryTable, const string ForeignCatalog, const string ForeignSchema, const string ForeignTable) |
returns cache key for GetCrossReference metadata entry | |
string | GetDatabaseProductName () |
What's the name of this database product? | |
string | GetDatabaseProductVersion () |
What's the version of this database product? | |
TZTransactIsolationLevel | GetDefaultTransactionIsolation () |
What's the database's default transaction isolation level? The values are defined in java.sql.Connection . | |
Integer | GetDriverMajorVersion () |
What's this JDBC driver's major version number? | |
Integer | GetDriverMinorVersion () |
What's this JDBC driver's minor version number? | |
string | GetDriverName () |
What's the name of this JDBC driver? | |
string | GetDriverVersion () |
What's the version of this JDBC driver? | |
IZResultSet | GetExportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). | |
string | GetExportedKeysCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetExportedKeys metadata entry | |
string | GetExtraNameCharacters () |
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). | |
IZIdentifierConvertor | GetIdentifierConvertor () |
Creates ab identifier convertor object. | |
string | GetIdentifierQuoteString () |
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported. | |
IZResultSet | GetImportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). | |
string | GetImportedKeysCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetImportedKeys metadata entry | |
IZResultSet | GetIndexInfo (const string Catalog, const string Schema, const string Table, Boolean Unique, Boolean Approximate) |
Gets a description of a table's indices and statistics. | |
string | GetIndexInfoCacheKey (const string Catalog, const string Schema, const string Table, const Boolean Unique, const Boolean Approximate) |
returns cache key for GetIndexInfo metadata entry | |
Integer | GetMaxBinaryLiteralLength () |
How many hex characters can you have in an inline binary literal? | |
Integer | GetMaxCatalogNameLength () |
What's the maximum length of a catalog name? | |
Integer | GetMaxCharLiteralLength () |
What's the max length for a character literal? | |
Integer | GetMaxColumnNameLength () |
What's the limit on column name length? | |
Integer | GetMaxColumnsInGroupBy () |
What's the maximum number of columns in a "GROUP BY" clause? | |
Integer | GetMaxColumnsInIndex () |
What's the maximum number of columns allowed in an index? | |
Integer | GetMaxColumnsInOrderBy () |
What's the maximum number of columns in an "ORDER BY" clause? | |
Integer | GetMaxColumnsInSelect () |
What's the maximum number of columns in a "SELECT" list? | |
Integer | GetMaxColumnsInTable () |
What's the maximum number of columns in a table? | |
Integer | GetMaxConnections () |
How many active connections can we have at a time to this database? | |
Integer | GetMaxCursorNameLength () |
What's the maximum cursor name length? | |
Integer | GetMaxIndexLength () |
Retrieves the maximum number of bytes for an index, including all of the parts of the index. | |
Integer | GetMaxProcedureNameLength () |
What's the maximum length of a procedure name? | |
Integer | GetMaxRowSize () |
What's the maximum length of a single row? | |
Integer | GetMaxSchemaNameLength () |
What's the maximum length allowed for a schema name? | |
Integer | GetMaxStatementLength () |
What's the maximum length of an SQL statement? | |
Integer | GetMaxStatements () |
How many active statements can we have open at one time to this database? | |
Integer | GetMaxTableNameLength () |
What's the maximum length of a table name? | |
Integer | GetMaxTablesInSelect () |
What's the maximum number of tables in a SELECT statement? | |
Integer | GetMaxUserNameLength () |
What's the maximum length of a user name? | |
string | GetNumericFunctions () |
Gets a comma-separated list of math functions. | |
IZResultSet | GetPrimaryKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's primary key columns. | |
string | GetPrimaryKeysCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetPrimaryKeys metadata entry | |
IZResultSet | GetProcedureColumns (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern, const string ColumnNamePattern) |
Gets a description of a catalog's stored procedure parameters and result columns. | |
string | GetProcedureColumnsCacheKey (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern, const string ColumnNamePattern) |
returns cache key for GetProcedureColumns metadata entry | |
IZResultSet | GetProcedures (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern) |
Gets a description of the stored procedures available in a catalog. | |
string | GetProceduresCacheKey (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern) |
returns cache key for GetProcedures metadata entry | |
string | GetProcedureTerm () |
What's the database vendor's preferred term for "procedure"? | |
IZResultSet | GetSchemas () |
Gets the schema names available in this database. | |
string | GetSchemasCacheKey () |
returns cache key for GetSchemas metadata entry | |
string | GetSchemaTerm () |
What's the database vendor's preferred term for "schema"? | |
string | GetSearchStringEscape () |
Gets the string that can be used to escape wildcard characters. | |
IZResultSet | GetSequences (const string Catalog, const string SchemaPattern, const string SequenceNamePattern) |
string | GetSequencesCacheKey (const string Catalog, const string SchemaPattern, const string SequenceNamePattern) |
returns cache key for GetSequences metadata entry | |
string | GetSQLKeywords () |
Gets a comma-separated list of all a database's SQL keywords that are NOT also SQL92 keywords. | |
string | GetStringFunctions () |
Gets a comma-separated list of string functions. | |
string | GetSystemFunctions () |
Gets a comma-separated list of system functions. | |
IZResultSet | GetTablePrivileges (const string Catalog, const string SchemaPattern, const string TableNamePattern) |
Gets a description of the access rights for each table available in a catalog. | |
string | GetTablePrivilegesCacheKey (const string Catalog, const string SchemaPattern, const string TableNamePattern) |
returns cache key for GetTablePrivileges metadata entry | |
IZResultSet | GetTables (const string Catalog, const string SchemaPattern, const string TableNamePattern, const TStringDynArray Types) |
Gets a description of tables available in a catalog. | |
string | GetTablesCacheKey (const string Catalog, const string SchemaPattern, const string TableNamePattern, const TStringDynArray Types) |
returns cache key for GetTables metadata entry | |
IZResultSet | GetTableTypes () |
Gets the table types available in this database. | |
string | GetTableTypesCacheKey () |
returns cache key for GetTableTypes metadata entry | |
string | GetTimeDateFunctions () |
Gets a comma-separated list of time and date functions. | |
IZResultSet | GetTypeInfo () |
Gets a description of all the standard SQL types supported by this database. | |
string | GetTypeInfoCacheKey () |
returns cache key for GetTypeInfo metadata entry | |
IZResultSet | GetUDTs (const string Catalog, const string SchemaPattern, const string TypeNamePattern, const TIntegerDynArray Types) |
Gets a description of the user-defined types defined in a particular schema. | |
string | GetUDTsCacheKey (const string Catalog, const string SchemaPattern, const string TypeNamePattern, const TIntegerDynArray Types) |
returns cache key for GetUDTs metadata entry | |
string | GetURL () |
What's the url for this database? | |
string | GetUserName () |
What's our user name as known to the database? | |
IZResultSet | GetVersionColumns (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's columns that are automatically updated when any value in a row is updated. | |
string | GetVersionColumnsCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetVersionColumns metadata entry | |
Boolean | IsCatalogAtStart () |
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end). | |
Boolean | IsReadOnly () |
Is the database in read-only mode? | |
Boolean | NullPlusNonNullIsNull () |
Are concatenations between NULL and non-NULL values NULL? For SQL-92 compliance, a JDBC technology-enabled driver will return true . | |
Boolean | NullsAreSortedAtEnd () |
Are NULL values sorted at the end regardless of sort order? | |
Boolean | NullsAreSortedAtStart () |
Are NULL values sorted at the start regardless of sort order? | |
Boolean | NullsAreSortedHigh () |
Are NULL values sorted high? | |
Boolean | NullsAreSortedLow () |
Are NULL values sorted low? | |
Boolean | StoresLowerCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case? | |
Boolean | StoresLowerCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case? | |
Boolean | StoresMixedCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case? | |
Boolean | StoresMixedCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case? | |
Boolean | StoresUpperCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case? | |
Boolean | StoresUpperCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case? | |
Boolean | SupportsAlterTableWithAddColumn () |
Is "ALTER TABLE" with add column supported? | |
Boolean | SupportsAlterTableWithDropColumn () |
Is "ALTER TABLE" with drop column supported? | |
Boolean | SupportsANSI92EntryLevelSQL () |
Is the ANSI92 entry level SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true. | |
Boolean | SupportsANSI92FullSQL () |
Is the ANSI92 full SQL grammar supported? | |
Boolean | SupportsANSI92IntermediateSQL () |
Is the ANSI92 intermediate SQL grammar supported? | |
Boolean | SupportsBatchUpdates () |
Indicates whether the driver supports batch updates. | |
Boolean | SupportsCatalogsInDataManipulation () |
Can a catalog name be used in a data manipulation statement? | |
Boolean | SupportsCatalogsInIndexDefinitions () |
Can a catalog name be used in an index definition statement? | |
Boolean | SupportsCatalogsInPrivilegeDefinitions () |
Can a catalog name be used in a privilege definition statement? | |
Boolean | SupportsCatalogsInProcedureCalls () |
Can a catalog name be used in a procedure call statement? | |
Boolean | SupportsCatalogsInTableDefinitions () |
Can a catalog name be used in a table definition statement? | |
Boolean | SupportsColumnAliasing () |
Is column aliasing supported? | |
Boolean | SupportsConvert () |
Is the CONVERT function between SQL types supported? | |
Boolean | SupportsConvertForTypes (TZSQLType FromType, TZSQLType ToType) |
Is CONVERT between the given SQL types supported? | |
Boolean | SupportsCoreSQLGrammar () |
Is the ODBC Core SQL grammar supported? | |
Boolean | SupportsCorrelatedSubqueries () |
Are correlated subqueries supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsDataDefinitionAndDataManipulationTransactions () |
Boolean | SupportsDataManipulationTransactionsOnly () |
Boolean | SupportsDifferentTableCorrelationNames () |
If table correlation names are supported, are they restricted to be different from the names of the tables? | |
Boolean | SupportsExpressionsInOrderBy () |
Are expressions in "ORDER BY" lists supported? | |
Boolean | SupportsExtendedSQLGrammar () |
Is the ODBC Extended SQL grammar supported? | |
Boolean | SupportsFullOuterJoins () |
Are full nested outer joins supported? | |
Boolean | SupportsGroupBy () |
Is some form of "GROUP BY" clause supported? | |
Boolean | SupportsGroupByBeyondSelect () |
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT? | |
Boolean | SupportsGroupByUnrelated () |
Can a "GROUP BY" clause use columns not in the SELECT? | |
Boolean | SupportsIntegrityEnhancementFacility () |
Is the SQL Integrity Enhancement Facility supported? | |
Boolean | SupportsLikeEscapeClause () |
Is the escape character in "LIKE" clauses supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsLimitedOuterJoins () |
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true. | |
Boolean | SupportsMinimumSQLGrammar () |
Is the ODBC Minimum SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true. | |
Boolean | SupportsMixedCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return false. | |
Boolean | SupportsMixedCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return true. | |
Boolean | SupportsMultipleResultSets () |
Are multiple ResultSet from a single execute supported? | |
Boolean | SupportsMultipleTransactions () |
Can we have multiple transactions open at once (on different connections)? | |
Boolean | SupportsNonNullableColumns () |
Can columns be defined as non-nullable? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsOpenCursorsAcrossCommit () |
Can cursors remain open across commits? | |
Boolean | SupportsOpenCursorsAcrossRollback () |
Can cursors remain open across rollbacks? | |
Boolean | SupportsOpenStatementsAcrossCommit () |
Can statements remain open across commits? | |
Boolean | SupportsOpenStatementsAcrossRollback () |
Can statements remain open across rollbacks? | |
Boolean | SupportsOrderByUnrelated () |
Can an "ORDER BY" clause use columns not in the SELECT statement? | |
Boolean | SupportsOuterJoins () |
Is some form of outer join supported? | |
Boolean | SupportsPositionedDelete () |
Is positioned DELETE supported? | |
Boolean | SupportsPositionedUpdate () |
Is positioned UPDATE supported? | |
Boolean | SupportsResultSetConcurrency (TZResultSetType _Type, TZResultSetConcurrency Concurrency) |
Does the database support the concurrency type in combination with the given result set type? | |
Boolean | SupportsResultSetType (TZResultSetType _Type) |
Does the database support the given result set type? | |
Boolean | SupportsSchemasInDataManipulation () |
Can a schema name be used in a data manipulation statement? | |
Boolean | SupportsSchemasInIndexDefinitions () |
Can a schema name be used in an index definition statement? | |
Boolean | SupportsSchemasInPrivilegeDefinitions () |
Can a schema name be used in a privilege definition statement? | |
Boolean | SupportsSchemasInProcedureCalls () |
Can a schema name be used in a procedure call statement? | |
Boolean | SupportsSchemasInTableDefinitions () |
Can a schema name be used in a table definition statement? | |
Boolean | SupportsSelectForUpdate () |
Is SELECT for UPDATE supported? | |
Boolean | SupportsStoredProcedures () |
Are stored procedure calls using the stored procedure escape syntax supported? | |
Boolean | SupportsSubqueriesInComparisons () |
Are subqueries in comparison expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsSubqueriesInExists () |
Are subqueries in 'exists' expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsSubqueriesInIns () |
Are subqueries in 'in' statements supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsSubqueriesInQuantifieds () |
Are subqueries in quantified expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsTableCorrelationNames () |
Are table correlation names supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsTransactionIsolationLevel (TZTransactIsolationLevel Level) |
Does this database support the given transaction isolation level? | |
Boolean | SupportsTransactions () |
Are transactions supported? If not, invoking the method commit is a noop and the isolation level is TRANSACTION_NONE. | |
Boolean | SupportsUnion () |
Is SQL UNION supported? | |
Boolean | SupportsUnionAll () |
Is SQL UNION ALL supported? | |
TZASADatabaseMetadata (TZAbstractConnection Connection, string Url, TStrings Info) | |
Constructs this object and assignes the main properties. | |
Boolean | UsesLocalFilePerTable () |
Does the database use a file for each table? | |
Boolean | UsesLocalFiles () |
Does the database store tables in a local file? | |
~TZASADatabaseMetadata () | |
Destroys this object and cleanups the memory. | |
Protected Types | |
typedef array< char > | WildcardsArray |
Protected Member Functions | |
string | AddEscapeCharToWildcards (const string Pattern) |
Add escape character in the pattern that has wildcards character. | |
AddResultSetToCache (const string Key, IZResultSet ResultSet) | |
Adds resultset to the internal cache. | |
IZResultSet | CloneCachedResultSet (IZResultSet ResultSet) |
Clones the cached resultset. | |
IZVirtualResultSet | ConstructVirtualResultSet (TZMetadataColumnDefs ColumnsDefs) |
Constructs a virtual result set object. | |
IZVirtualResultSet | CopyToVirtualResultSet (IZResultSet SrcResultSet, IZVirtualResultSet DestResultSet) |
Copies on result set to another one from the current position. | |
FillWildcards () | |
Set the Wildcards character for WildcardsArray variable. | |
IZResultSet | GetResultSetFromCache (const string Key) |
Gets a resultset interface from the internal cache by key. | |
IZStatement | GetStatement () |
Create a statement for use. | |
TZWildcardsSet | GetWildcardsSet () |
Get the Wildscards in set of char type. | |
IZResultSet | UncachedGetBestRowIdentifier (const string Catalog, const string Schema, const string Table, Integer Scope, Boolean Nullable) |
Gets a description of a table's optimal set of columns that uniquely identifies a row. | |
IZResultSet | UncachedGetCatalogs () |
Gets the catalog names available in this database. | |
IZResultSet | UncachedGetColumnPrivileges (const string Catalog, const string Schema, const string Table, const string ColumnNamePattern) |
Gets a description of the access rights for a table's columns. | |
IZResultSet | UncachedGetColumns (const string Catalog, const string SchemaPattern, const string TableNamePattern, const string ColumnNamePattern) |
Gets a description of table columns available in the specified catalog. | |
IZResultSet | UncachedGetCrossReference (const string PrimaryCatalog, const string PrimarySchema, const string PrimaryTable, const string ForeignCatalog, const string ForeignSchema, const string ForeignTable) |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key. | |
IZResultSet | UncachedGetExportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). | |
IZResultSet | UncachedGetImportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). | |
IZResultSet | UncachedGetIndexInfo (const string Catalog, const string Schema, const string Table, Boolean Unique, Boolean Approximate) |
Gets a description of a table's indices and statistics. | |
IZResultSet | UncachedGetPrimaryKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's primary key columns. | |
IZResultSet | UncachedGetProcedureColumns (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern, const string ColumnNamePattern) |
Gets a description of a catalog's stored procedure parameters and result columns. | |
IZResultSet | UncachedGetProcedures (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern) |
Gets a description of the stored procedures available in a catalog. | |
IZResultSet | UncachedGetSchemas () |
Gets the schema names available in this database. | |
IZResultSet | UncachedGetSequences (const string Catalog, const string SchemaPattern, const string SequenceNamePattern) |
IZResultSet | UncachedGetTablePrivileges (const string Catalog, const string SchemaPattern, const string TableNamePattern) |
Gets a description of the access rights for each table available in a catalog. | |
IZResultSet | UncachedGetTables (const string Catalog, const string SchemaPattern, const string TableNamePattern, const TStringDynArray Types) |
Gets a description of tables available in a catalog. | |
IZResultSet | UncachedGetTableTypes () |
Gets the table types available in this database. | |
IZResultSet | UncachedGetTypeInfo () |
Gets a description of all the standard SQL types supported by this database. | |
IZResultSet | UncachedGetUDTs (const string Catalog, const string SchemaPattern, const string TypeNamePattern, const TIntegerDynArray Types) |
Gets a description of the user-defined types defined in a particular schema. | |
IZResultSet | UncachedGetVersionColumns (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's columns that are automatically updated when any value in a row is updated. | |
Protected Attributes | |
IZHashMap | CachedResultSets |
TStrings | Info |
string | Url |
Private Attributes | |
TZASAConnection | FASAConnection |
Definition at line 71 of file ZDbcASAMetadata.pas.
typedef array<char> TZAbstractDatabaseMetadata::WildcardsArray [protected, inherited] |
Definition at line 168 of file ZDbcMetadata.pas.
TZASADatabaseMetadata::TZASADatabaseMetadata | ( | TZAbstractConnection | Connection, | |
string | Url, | |||
TStrings | Info | |||
) |
Constructs this object and assignes the main properties.
Connection | a database connection object. | |
Url | a database connection url string. | |
Info | an extra connection properties. |
Definition at line 483 of file ZDbcASAMetadata.pas.
References P.
TZASADatabaseMetadata::~TZASADatabaseMetadata | ( | ) |
string TZAbstractDatabaseMetadata::AddEscapeCharToWildcards | ( | const string | Pattern | ) | [protected, inherited] |
Add escape character in the pattern that has wildcards character.
Pattern | The pattern that would be escaped |
Reimplemented from IZDatabaseMetadata.
Definition at line 5052 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::AddResultSetToCache | ( | const string | Key, | |
IZResultSet | ResultSet | |||
) | [protected, inherited] |
Adds resultset to the internal cache.
Key | a resultset unique key value. | |
ResultSet | a resultset interface. |
Definition at line 1206 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::AllProceduresAreCallable | ( | ) | [inherited] |
Can all the procedures returned by getProcedures be called by the current user?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1373 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::AllTablesAreSelectable | ( | ) | [inherited] |
Can all the tables returned by getTable be SELECTed by the current user?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1386 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::ClearCache | ( | const string | Key | ) | [inherited] |
Clears specific cached metadata.
Reimplemented from IZDatabaseMetadata.
Definition at line 1184 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::ClearCache | ( | ) | [inherited] |
Clears all cached metadata.
Reimplemented from IZDatabaseMetadata.
Definition at line 1173 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::CloneCachedResultSet | ( | IZResultSet | ResultSet | ) | [protected, inherited] |
Clones the cached resultset.
ResultSet | the resultset to be cloned. |
Definition at line 1326 of file ZDbcMetadata.pas.
IZVirtualResultSet TZAbstractDatabaseMetadata::ConstructVirtualResultSet | ( | TZMetadataColumnDefs | ColumnsDefs | ) | [protected, inherited] |
Constructs a virtual result set object.
ColumnsDefs | an array of column definition objects. |
Definition at line 1135 of file ZDbcMetadata.pas.
IZVirtualResultSet TZAbstractDatabaseMetadata::CopyToVirtualResultSet | ( | IZResultSet | SrcResultSet, | |
IZVirtualResultSet | DestResultSet | |||
) | [protected, inherited] |
Copies on result set to another one from the current position.
SrcResultSet | a source result set. | |
DestResultSet | a destination result set. |
Definition at line 1255 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::DataDefinitionCausesTransactionCommit | ( | ) |
Does a data definition statement within a transaction force the transaction to commit?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1643 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::DataDefinitionIgnoredInTransactions | ( | ) |
Is a data definition statement within a transaction ignored?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1655 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::DoesMaxRowSizeIncludeBlobs | ( | ) |
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1493 of file ZDbcASAMetadata.pas.
TZAbstractDatabaseMetadata::FillWildcards | ( | ) | [protected, inherited] |
Set the Wildcards character for WildcardsArray variable.
Overrride this method if the wildcards character is different in other database
Definition at line 5076 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetBestRowIdentifier | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Integer | Scope, | |||
Boolean | Nullable | |||
) | [inherited] |
Gets a description of a table's optimal set of columns that uniquely identifies a row.
They are ordered by SCOPE.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
scope | the scope of interest; use same values as SCOPE | |
nullable | include columns that are nullable? |
ResultSet
- each row is a column description Reimplemented from IZDatabaseMetadata.
Definition at line 3764 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetBestRowIdentifierCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const Integer | Scope, | |||
const Boolean | Nullable | |||
) | [inherited] |
returns cache key for GetBestRowIdentifier metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name | |
Scope | the scope of interest | |
Nullable | include columns that are nullable? |
Definition at line 5292 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::GetCacheKeys | ( | TStrings | List | ) | [inherited] |
fills string list with the keys for the currently cached metadata entries
List | a string list to fill out |
Definition at line 5497 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetCatalogs | ( | ) | [inherited] |
Gets the catalog names available in this database.
The results are ordered by catalog name.
The catalog column is:
ResultSet
- each row has a single String column that is a catalog name Reimplemented from IZDatabaseMetadata.
Definition at line 3301 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetCatalogsCacheKey | ( | ) | [inherited] |
returns cache key for GetCatalogs metadata entry
Definition at line 5202 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetCatalogSeparator | ( | ) |
What's the separator between catalog and table name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 967 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetCatalogTerm | ( | ) |
What's the database vendor's preferred term for "catalog"?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 955 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetColumnPrivileges | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
Gets a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column privilege description Reimplemented from IZDatabaseMetadata.
Definition at line 3564 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetColumnPrivilegesCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
returns cache key for GetColumnPrivileges metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name | |
ColumnNamePattern | a column name pattern |
Definition at line 5251 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
Gets a description of table columns available in the specified catalog.
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column description Reimplemented from IZDatabaseMetadata.
Definition at line 3448 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetColumnsCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
returns cache key for GetColumns metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TableNamePattern | a table name pattern | |
ColumnNamePattern | a column name pattern |
Definition at line 5230 of file ZDbcMetadata.pas.
IZConnection TZAbstractDatabaseMetadata::GetConnection | ( | ) | [inherited] |
Retrieves the connection that produced this metadata object.
Reimplemented from IZDatabaseMetadata.
Definition at line 1122 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetCrossReference | ( | const string | PrimaryCatalog, | |
const string | PrimarySchema, | |||
const string | PrimaryTable, | |||
const string | ForeignCatalog, | |||
const string | ForeignSchema, | |||
const string | ForeignTable | |||
) | [inherited] |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.
) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
primaryCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
primarySchema | a schema name; "" retrieves those without a schema | |
primaryTable | the table name that exports the key | |
foreignCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
foreignSchema | a schema name; "" retrieves those without a schema | |
foreignTable | the table name that imports the key |
ResultSet
- each row is a foreign key column description Reimplemented from IZDatabaseMetadata.
Definition at line 4474 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetCrossReferenceCacheKey | ( | const string | PrimaryCatalog, | |
const string | PrimarySchema, | |||
const string | PrimaryTable, | |||
const string | ForeignCatalog, | |||
const string | ForeignSchema, | |||
const string | ForeignTable | |||
) | [inherited] |
returns cache key for GetCrossReference metadata entry
PrimaryCatalog | a catalog name for the primary table | |
PrimarySchema | a schema name for the primary table | |
PrimaryTable | the table name that exports the key | |
ForeignCatalog | a catalog name for the foreign table | |
ForeignSchema | a schema name for the foreign table | |
ForeignTable | the table name that imports the key |
Definition at line 5388 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetDatabaseProductName | ( | ) |
What's the name of this database product?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 525 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetDatabaseProductVersion | ( | ) |
What's the version of this database product?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 537 of file ZDbcASAMetadata.pas.
TZTransactIsolationLevel TZASADatabaseMetadata::GetDefaultTransactionIsolation | ( | ) |
What's the database's default transaction isolation level? The values are defined in java.sql.Connection
.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1576 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetDriverMajorVersion | ( | ) |
What's this JDBC driver's major version number?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 561 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetDriverMinorVersion | ( | ) |
What's this JDBC driver's minor version number?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 573 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetDriverName | ( | ) |
What's the name of this JDBC driver?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 549 of file ZDbcASAMetadata.pas.
string TZAbstractDatabaseMetadata::GetDriverVersion | ( | ) | [inherited] |
What's the version of this JDBC driver?
Reimplemented from IZDatabaseMetadata.
Definition at line 1520 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetExportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a foreign key column description Reimplemented from IZDatabaseMetadata.
Definition at line 4298 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetExportedKeysCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetExportedKeys metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5367 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetExtraNameCharacters | ( | ) |
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 843 of file ZDbcASAMetadata.pas.
IZIdentifierConvertor TZAbstractDatabaseMetadata::GetIdentifierConvertor | ( | ) | [inherited] |
Creates ab identifier convertor object.
Reimplemented from IZDatabaseMetadata.
Definition at line 5039 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetIdentifierQuoteString | ( | ) | [inherited] |
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.
A JDBC Compliant<font size="-2">TM</font> driver always uses a double quote character.
Reimplemented from IZDatabaseMetadata.
Reimplemented in TZAdoDatabaseMetadata, TZMsSqlDatabaseMetadata, TZSybaseDatabaseMetadata, and TZMySQLDatabaseMetadata.
Definition at line 1689 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetImportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description Reimplemented from IZDatabaseMetadata.
Definition at line 4130 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetImportedKeysCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetImportedKeys metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5349 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetIndexInfo | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Boolean | Unique, | |||
Boolean | Approximate | |||
) | [inherited] |
Gets a description of a table's indices and statistics.
They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
unique | when true, return only indices for unique values; when false, return indices regardless of whether unique or not | |
approximate | when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate |
ResultSet
- each row is an index column description Reimplemented from IZDatabaseMetadata.
Definition at line 4760 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetIndexInfoCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const Boolean | Unique, | |||
const Boolean | Approximate | |||
) | [inherited] |
returns cache key for GetIndexInfo metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name | |
Unique | when true, return key for a metadata entry that should contain only indices for unique values; when false, return key for a metadata entry that may contain indices to non-unique values | |
Approximate | when true, return key for a metadata entry that may include approximate or out of data values; when false, return key for a metadata entry that should contain only accurate results |
Definition at line 5429 of file ZDbcMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxBinaryLiteralLength | ( | ) |
How many hex characters can you have in an inline binary literal?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1296 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxCatalogNameLength | ( | ) |
What's the maximum length of a catalog name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1467 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxCharLiteralLength | ( | ) |
What's the max length for a character literal?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1309 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxColumnNameLength | ( | ) |
What's the limit on column name length?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1322 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxColumnsInGroupBy | ( | ) |
What's the maximum number of columns in a "GROUP BY" clause?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1335 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxColumnsInIndex | ( | ) |
What's the maximum number of columns allowed in an index?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1348 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxColumnsInOrderBy | ( | ) |
What's the maximum number of columns in an "ORDER BY" clause?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1361 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxColumnsInSelect | ( | ) |
What's the maximum number of columns in a "SELECT" list?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1374 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxColumnsInTable | ( | ) |
What's the maximum number of columns in a table?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1387 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxConnections | ( | ) |
How many active connections can we have at a time to this database?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1400 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxCursorNameLength | ( | ) |
What's the maximum cursor name length?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1413 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxIndexLength | ( | ) |
Retrieves the maximum number of bytes for an index, including all of the parts of the index.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1428 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxProcedureNameLength | ( | ) |
What's the maximum length of a procedure name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1454 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxRowSize | ( | ) |
What's the maximum length of a single row?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1480 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxSchemaNameLength | ( | ) |
What's the maximum length allowed for a schema name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1441 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxStatementLength | ( | ) |
What's the maximum length of an SQL statement?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1506 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxStatements | ( | ) |
How many active statements can we have open at one time to this database?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1520 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxTableNameLength | ( | ) |
What's the maximum length of a table name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1533 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxTablesInSelect | ( | ) |
What's the maximum number of tables in a SELECT statement?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1546 of file ZDbcASAMetadata.pas.
Integer TZASADatabaseMetadata::GetMaxUserNameLength | ( | ) |
What's the maximum length of a user name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1559 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetNumericFunctions | ( | ) |
Gets a comma-separated list of math functions.
These are the X/Open CLI math function names used in the JDBC function escape clause.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 754 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetPrimaryKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of a table's primary key columns.
They are ordered by COLUMN_NAME.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description SQLException | if a database access error occurs |
Reimplemented from IZDatabaseMetadata.
Definition at line 4007 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetPrimaryKeysCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetPrimaryKeys metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5331 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetProcedureColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
Gets a description of a catalog's stored procedure parameters and result columns.
Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description or column description with the following fields:
ResultSet
Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row describes a stored procedure parameter or column Reimplemented from IZDatabaseMetadata.
Definition at line 3049 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetProcedureColumnsCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
returns cache key for GetProcedureColumns metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
ProcedureNamePattern | a procedure name pattern | |
ColumnNamePattern | a column name pattern |
Definition at line 5140 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetProcedures | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern | |||
) | [inherited] |
Gets a description of the stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
Each procedure description has the the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern |
ResultSet
- each row is a procedure description Reimplemented from IZDatabaseMetadata.
Definition at line 2926 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetProceduresCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern | |||
) | [inherited] |
returns cache key for GetProcedures metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
ProcedureNamePattern | a procedure name pattern |
Definition at line 5120 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetProcedureTerm | ( | ) |
What's the database vendor's preferred term for "procedure"?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 943 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetResultSetFromCache | ( | const string | Key | ) | [protected, inherited] |
Gets a resultset interface from the internal cache by key.
Key | a resultset unique key value. |
nil
otherwise. Definition at line 1229 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetSchemas | ( | ) | [inherited] |
Gets the schema names available in this database.
The results are ordered by schema name.
The schema column is:
ResultSet
- each row has a single String column that is a schema name Reimplemented from IZDatabaseMetadata.
Definition at line 3249 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetSchemasCacheKey | ( | ) | [inherited] |
returns cache key for GetSchemas metadata entry
Definition at line 5190 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetSchemaTerm | ( | ) |
What's the database vendor's preferred term for "schema"?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 931 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetSearchStringEscape | ( | ) |
Gets the string that can be used to escape wildcard characters.
This is the string that can be used to escape '_' or '' in the string pattern style catalog search parameters.
The '_' character represents any single character.
The '' character represents any sequence of zero or more characters.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 830 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetSequences | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | SequenceNamePattern | |||
) | [inherited] |
string TZAbstractDatabaseMetadata::GetSequencesCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | SequenceNamePattern | |||
) | [inherited] |
returns cache key for GetSequences metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
SequenceNamePattern | a sequence name pattern |
Definition at line 5450 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetSQLKeywords | ( | ) |
Gets a comma-separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 716 of file ZDbcASAMetadata.pas.
IZStatement TZASADatabaseMetadata::GetStatement | ( | ) | [protected] |
Create a statement for use.
Definition at line 3040 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetStringFunctions | ( | ) |
Gets a comma-separated list of string functions.
These are the X/Open CLI string function names used in the JDBC function escape clause.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 770 of file ZDbcASAMetadata.pas.
string TZASADatabaseMetadata::GetSystemFunctions | ( | ) |
Gets a comma-separated list of system functions.
These are the X/Open CLI system function names used in the JDBC function escape clause.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 788 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTablePrivileges | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern | |||
) | [inherited] |
Gets a description of the access rights for each table available in a catalog.
Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.)
Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern |
ResultSet
- each row is a table privilege description Reimplemented from IZDatabaseMetadata.
Definition at line 3661 of file ZDbcMetadata.pas.
References P.
string TZAbstractDatabaseMetadata::GetTablePrivilegesCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern | |||
) | [inherited] |
returns cache key for GetTablePrivileges metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TableNamePattern | a table name pattern |
Definition at line 5271 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTables | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const TStringDynArray | Types | |||
) | [inherited] |
Gets a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
Note: Some databases may not return information for all tables.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
types | a list of table types to include; null returns all types |
ResultSet
- each row is a table description Reimplemented from IZDatabaseMetadata.
Definition at line 3172 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetTablesCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const TStringDynArray | Types | |||
) | [inherited] |
returns cache key for GetTables metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TableNamePattern | a table name pattern | |
Types | table types list |
Definition at line 5161 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTableTypes | ( | ) | [inherited] |
Gets the table types available in this database.
The results are ordered by table type.
The table type is:
ResultSet
- each row has a single String column that is a table type Reimplemented from IZDatabaseMetadata.
Definition at line 3355 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetTableTypesCacheKey | ( | ) | [inherited] |
returns cache key for GetTableTypes metadata entry
Definition at line 5214 of file ZDbcMetadata.pas.
string TZASADatabaseMetadata::GetTimeDateFunctions | ( | ) |
Gets a comma-separated list of time and date functions.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 809 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTypeInfo | ( | ) | [inherited] |
Gets a description of all the standard SQL types supported by this database.
They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
ResultSet
- each row is an SQL type description Reimplemented from IZDatabaseMetadata.
Definition at line 4636 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetTypeInfoCacheKey | ( | ) | [inherited] |
returns cache key for GetTypeInfo metadata entry
Definition at line 5408 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetUDTs | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TypeNamePattern, | |||
const TIntegerDynArray | Types | |||
) | [inherited] |
Gets a description of the user-defined types defined in a particular schema.
Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
Only types matching the catalog, schema, type name and type criteria are returned. They are ordered by DATA_TYPE, TYPE_SCHEM and TYPE_NAME. The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
Note: If the driver does not support UDTs, an empty result set is returned.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
typeNamePattern | a type name pattern; may be a fully-qualified name | |
types | a list of user-named types to include (JAVA_OBJECT, STRUCT, or DISTINCT); null returns all types |
ResultSet
- each row is a type description Reimplemented from IZDatabaseMetadata.
Definition at line 4962 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetUDTsCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TypeNamePattern, | |||
const TIntegerDynArray | Types | |||
) | [inherited] |
returns cache key for GetUDTs metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TypeNamePattern | a type name pattern | |
Types | a list of user-named types to include |
Definition at line 5470 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetURL | ( | ) | [inherited] |
What's the url for this database?
Reimplemented from IZDatabaseMetadata.
Definition at line 1398 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetUserName | ( | ) | [inherited] |
What's our user name as known to the database?
Reimplemented from IZDatabaseMetadata.
Definition at line 1410 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetVersionColumns | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of a table's columns that are automatically updated when any value in a row is updated.
They are unordered.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a column description SQLException | if a database access error occurs |
Reimplemented from IZDatabaseMetadata.
Definition at line 3921 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetVersionColumnsCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetVersionColumns metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5313 of file ZDbcMetadata.pas.
TZWildcardsSet TZAbstractDatabaseMetadata::GetWildcardsSet | ( | ) | [protected, inherited] |
Get the Wildscards in set of char type.
Definition at line 5094 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::IsCatalogAtStart | ( | ) | [inherited] |
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end).
Reimplemented from IZDatabaseMetadata.
Definition at line 2185 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::IsReadOnly | ( | ) | [inherited] |
Is the database in read-only mode?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1424 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullPlusNonNullIsNull | ( | ) | [inherited] |
Are concatenations between NULL and non-NULL values NULL? For SQL-92 compliance, a JDBC technology-enabled driver will return true
.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1846 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedAtEnd | ( | ) | [inherited] |
Are NULL values sorted at the end regardless of sort order?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1472 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::NullsAreSortedAtStart | ( | ) |
Are NULL values sorted at the start regardless of sort order?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 513 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedHigh | ( | ) | [inherited] |
Are NULL values sorted high?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1436 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedLow | ( | ) | [inherited] |
Are NULL values sorted low?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1448 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::StoresLowerCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 637 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::StoresLowerCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 690 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::StoresMixedCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 650 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::StoresMixedCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 703 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::StoresUpperCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 624 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::StoresUpperCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 677 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsAlterTableWithAddColumn | ( | ) | [inherited] |
Is "ALTER TABLE" with add column supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1803 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsAlterTableWithDropColumn | ( | ) | [inherited] |
Is "ALTER TABLE" with drop column supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1815 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsANSI92EntryLevelSQL | ( | ) | [inherited] |
Is the ANSI92 entry level SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2063 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsANSI92FullSQL | ( | ) | [inherited] |
Is the ANSI92 full SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2087 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsANSI92IntermediateSQL | ( | ) | [inherited] |
Is the ANSI92 intermediate SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2075 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsBatchUpdates | ( | ) | [inherited] |
Indicates whether the driver supports batch updates.
Reimplemented from IZDatabaseMetadata.
Definition at line 4919 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsCatalogsInDataManipulation | ( | ) |
Can a catalog name be used in a data manipulation statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1039 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsCatalogsInIndexDefinitions | ( | ) |
Can a catalog name be used in an index definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1075 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsCatalogsInPrivilegeDefinitions | ( | ) |
Can a catalog name be used in a privilege definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1087 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsCatalogsInProcedureCalls | ( | ) |
Can a catalog name be used in a procedure call statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1051 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsCatalogsInTableDefinitions | ( | ) |
Can a catalog name be used in a table definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1063 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsColumnAliasing | ( | ) | [inherited] |
Is column aliasing supported?
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required. A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1832 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsConvert | ( | ) | [inherited] |
Is the CONVERT function between SQL types supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1858 of file ZDbcMetadata.pas.
References P.
Boolean TZAbstractDatabaseMetadata::SupportsConvertForTypes | ( | TZSQLType | FromType, | |
TZSQLType | ToType | |||
) | [inherited] |
Is CONVERT between the given SQL types supported?
fromType | the type to convert from | |
toType | the type to convert to |
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1873 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsCoreSQLGrammar | ( | ) | [inherited] |
Is the ODBC Core SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2038 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsCorrelatedSubqueries | ( | ) |
Are correlated subqueries supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1201 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsDataDefinitionAndDataManipulationTransactions | ( | ) |
Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZASADatabaseMetadata::SupportsDataManipulationTransactionsOnly | ( | ) |
Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZAbstractDatabaseMetadata::SupportsDifferentTableCorrelationNames | ( | ) | [inherited] |
If table correlation names are supported, are they restricted to be different from the names of the tables?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1901 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsExpressionsInOrderBy | ( | ) |
Are expressions in "ORDER BY" lists supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 858 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsExtendedSQLGrammar | ( | ) | [inherited] |
Is the ODBC Extended SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2050 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsFullOuterJoins | ( | ) | [inherited] |
Are full nested outer joins supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2123 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsGroupBy | ( | ) |
Is some form of "GROUP BY" clause supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 882 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsGroupByBeyondSelect | ( | ) |
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 907 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsGroupByUnrelated | ( | ) |
Can a "GROUP BY" clause use columns not in the SELECT?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 894 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsIntegrityEnhancementFacility | ( | ) |
Is the SQL Integrity Enhancement Facility supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 919 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsLikeEscapeClause | ( | ) | [inherited] |
Is the escape character in "LIKE" clauses supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1975 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsLimitedOuterJoins | ( | ) | [inherited] |
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.
)
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2136 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsMinimumSQLGrammar | ( | ) | [inherited] |
Is the ODBC Minimum SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2026 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsMixedCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return false.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 611 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsMixedCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 664 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsMultipleResultSets | ( | ) | [inherited] |
Are multiple ResultSet
from a single execute supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1987 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsMultipleTransactions | ( | ) | [inherited] |
Can we have multiple transactions open at once (on different connections)?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2000 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsNonNullableColumns | ( | ) | [inherited] |
Can columns be defined as non-nullable? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2013 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsOpenCursorsAcrossCommit | ( | ) |
Can cursors remain open across commits?
true
if cursors always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1238 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsOpenCursorsAcrossRollback | ( | ) |
Can cursors remain open across rollbacks?
true
if cursors always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1251 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsOpenStatementsAcrossCommit | ( | ) |
Can statements remain open across commits?
true
if statements always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1264 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsOpenStatementsAcrossRollback | ( | ) |
Can statements remain open across rollbacks?
true
if statements always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1277 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsOrderByUnrelated | ( | ) |
Can an "ORDER BY" clause use columns not in the SELECT statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 870 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsOuterJoins | ( | ) | [inherited] |
Is some form of outer join supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2111 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsPositionedDelete | ( | ) |
Is positioned DELETE supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1099 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsPositionedUpdate | ( | ) |
Is positioned UPDATE supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1111 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsResultSetConcurrency | ( | TZResultSetType | _Type, | |
TZResultSetConcurrency | Concurrency | |||
) |
Does the database support the concurrency type in combination with the given result set type?
type | defined in java.sql.ResultSet | |
concurrency | type defined in java.sql.ResultSet |
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2944 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsResultSetType | ( | TZResultSetType | _Type | ) |
Does the database support the given result set type?
type | defined in java.sql.ResultSet |
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2927 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSchemasInDataManipulation | ( | ) |
Can a schema name be used in a data manipulation statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 979 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSchemasInIndexDefinitions | ( | ) |
Can a schema name be used in an index definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1015 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSchemasInPrivilegeDefinitions | ( | ) |
Can a schema name be used in a privilege definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1027 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSchemasInProcedureCalls | ( | ) |
Can a schema name be used in a procedure call statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 991 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSchemasInTableDefinitions | ( | ) |
Can a schema name be used in a table definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1003 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSelectForUpdate | ( | ) |
Is SELECT for UPDATE supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1123 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsStoredProcedures | ( | ) |
Are stored procedure calls using the stored procedure escape syntax supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1136 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSubqueriesInComparisons | ( | ) |
Are subqueries in comparison expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1149 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSubqueriesInExists | ( | ) |
Are subqueries in 'exists' expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1162 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSubqueriesInIns | ( | ) |
Are subqueries in 'in' statements supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1175 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsSubqueriesInQuantifieds | ( | ) |
Are subqueries in quantified expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1188 of file ZDbcASAMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsTableCorrelationNames | ( | ) | [inherited] |
Are table correlation names supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1888 of file ZDbcMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsTransactionIsolationLevel | ( | TZTransactIsolationLevel | Level | ) |
Does this database support the given transaction isolation level?
level | the values are defined in java.sql.Connection |
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1603 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsTransactions | ( | ) |
Are transactions supported? If not, invoking the method commit
is a noop and the isolation level is TRANSACTION_NONE.
true
if transactions are supported; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1589 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsUnion | ( | ) |
Is SQL UNION supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1213 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::SupportsUnionAll | ( | ) |
Is SQL UNION ALL supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1225 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::UncachedGetBestRowIdentifier | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Integer | Scope, | |||
Boolean | Nullable | |||
) | [protected, inherited] |
Gets a description of a table's optimal set of columns that uniquely identifies a row.
They are ordered by SCOPE.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
scope | the scope of interest; use same values as SCOPE | |
nullable | include columns that are nullable? |
ResultSet
- each row is a column description Definition at line 3826 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::UncachedGetCatalogs | ( | ) | [protected, inherited] |
Gets the catalog names available in this database.
The results are ordered by catalog name.
The catalog column is:
ResultSet
- each row has a single String column that is a catalog name Reimplemented in TZAdoDatabaseMetadata, TZMsSqlDatabaseMetadata, TZSybaseDatabaseMetadata, TZMySQLDatabaseMetadata, and TZPostgreSQLDatabaseMetadata.
Definition at line 3333 of file ZDbcMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetColumnPrivileges | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const string | ColumnNamePattern | |||
) | [protected] |
Gets a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column privilege description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2139 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const string | ColumnNamePattern | |||
) | [protected] |
Gets a description of table columns available in the specified catalog.
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2024 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetCrossReference | ( | const string | PrimaryCatalog, | |
const string | PrimarySchema, | |||
const string | PrimaryTable, | |||
const string | ForeignCatalog, | |||
const string | ForeignSchema, | |||
const string | ForeignTable | |||
) | [protected] |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.
) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
primaryCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
primarySchema | a schema name; "" retrieves those without a schema | |
primaryTable | the table name that exports the key | |
foreignCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
foreignSchema | a schema name; "" retrieves those without a schema | |
foreignTable | the table name that imports the key |
ResultSet
- each row is a foreign key column description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2661 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetExportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a foreign key column description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2539 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetImportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2425 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetIndexInfo | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Boolean | Unique, | |||
Boolean | Approximate | |||
) | [protected] |
Gets a description of a table's indices and statistics.
They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
unique | when true, return only indices for unique values; when false, return indices regardless of whether unique or not | |
approximate | when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate |
ResultSet
- each row is an index column description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2858 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetPrimaryKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of a table's primary key columns.
They are ordered by COLUMN_NAME.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description SQLException | if a database access error occurs |
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2327 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetProcedureColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern, | |||
const string | ColumnNamePattern | |||
) | [protected] |
Gets a description of a catalog's stored procedure parameters and result columns.
Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description or column description with the following fields:
ResultSet
Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row describes a stored procedure parameter or column Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1781 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetProcedures | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern | |||
) | [protected] |
Gets a description of the stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
Each procedure description has the the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern |
ResultSet
- each row is a procedure description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1696 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetSchemas | ( | ) | [protected] |
Gets the schema names available in this database.
The results are ordered by schema name.
The schema column is:
ResultSet
- each row has a single String column that is a schema name Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1922 of file ZDbcASAMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::UncachedGetSequences | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | SequenceNamePattern | |||
) | [protected, inherited] |
Reimplemented in TZInterbase6DatabaseMetadata, and TZPostgreSQLDatabaseMetadata.
Definition at line 4872 of file ZDbcMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetTablePrivileges | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern | |||
) | [protected] |
Gets a description of the access rights for each table available in a catalog.
Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.)
Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern |
ResultSet
- each row is a table privilege description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2207 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetTables | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const TStringDynArray | Types | |||
) | [protected] |
Gets a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
Note: Some databases may not return information for all tables.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
types | a list of table types to include; null returns all types |
ResultSet
- each row is a table description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1865 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetTableTypes | ( | ) | [protected] |
Gets the table types available in this database.
The results are ordered by table type.
The table type is:
ResultSet
- each row has a single String column that is a table type Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1951 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetTypeInfo | ( | ) | [protected] |
Gets a description of all the standard SQL types supported by this database.
They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
ResultSet
- each row is an SQL type description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2757 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetUDTs | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TypeNamePattern, | |||
const TIntegerDynArray | Types | |||
) | [protected] |
Gets a description of the user-defined types defined in a particular schema.
Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
Only types matching the catalog, schema, type name and type criteria are returned. They are ordered by DATA_TYPE, TYPE_SCHEM and TYPE_NAME. The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
Note: If the driver does not support UDTs, an empty result set is returned.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
typeNamePattern | a type name pattern; may be a fully-qualified name | |
types | a list of user-named types to include (JAVA_OBJECT, STRUCT, or DISTINCT); null returns all types |
ResultSet
- each row is a type description Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2988 of file ZDbcASAMetadata.pas.
IZResultSet TZASADatabaseMetadata::UncachedGetVersionColumns | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of a table's columns that are automatically updated when any value in a row is updated.
They are unordered.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a column description SQLException | if a database access error occurs |
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 2270 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::UsesLocalFilePerTable | ( | ) |
Does the database use a file for each table?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 597 of file ZDbcASAMetadata.pas.
Boolean TZASADatabaseMetadata::UsesLocalFiles | ( | ) |
Does the database store tables in a local file?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 585 of file ZDbcASAMetadata.pas.
IZHashMap TZAbstractDatabaseMetadata::CachedResultSets [protected, inherited] |
FCachedResultSets For writing
Definition at line 214 of file ZDbcMetadata.pas.
Definition at line 76 of file ZDbcASAMetadata.pas.
TStrings TZAbstractDatabaseMetadata::Info [protected, inherited] |
string TZAbstractDatabaseMetadata::Url [protected, inherited] |