Specifies the options available when retrieving metadata from a target database.
MetaDataOption: Integer = 1 shl ord(grMetaData);
int MetaDataOption = 1 shl ord(grMetaData);
Provider
Each database provides a number of options for data that can be retrieved from and about the database. When you build your own data provider, it can be helpful to use these options when implementing the ISQLMetaData interface. The following table describes the allowable metadata options.
|
Element |
Description |
|
CatalogName |
Specifies a system table name. |
|
DatabaseName |
Specifies the name of the database. |
|
DatabaseVersion |
Specifies the version number of the database. |
|
MaxColumnInSelect |
Limits the number of columns that can be specified in a SELECT statement. The column count starts with the first column. Any columns beyond the limit are not returned. |
|
MaxColumnsInTable |
Limits the number of columns that can be returned from a table. The column count starts with the first column. Any columns beyond the limit are not returned. |
|
MaxObjectNameLength |
Limits the number of characters returned of a database object name. Names exceeding this limit are truncated. If database object names are similar, truncating them might result in duplicate names or meaningless names. |
|
MaxRowSize |
Limits the size of any returned rows. This can be useful if you suspect there might be BLOBs in the rows you are selecting, but you want to protect the performance of your query. |
|
MaxSQLLength |
Limits the length, in characters, of a SQL statement. |
|
ObjectQuoteChar |
Specifies the quote character to use when delimiting object names containing special characters, such as spaces. |
|
PackageName |
Specifies the name of a package. |
|
ProcSupportsCursor |
Specifies whether or not a stored procedure supports the use of a cursor. Set to true if it supports a cursor, otherwise set to false. |
|
ProcSupportsCursors |
Specifies whether or not a stored procedure supports the use of multiple cursors. Set to true if it supports cursors, otherwise set to false. |
|
SQLEscapeChar |
Specifies the character to use to delimit escape sequences in SQL statements. |
|
SchemaName |
Specifies the name of a database schema if different from the DatabaseName. |
|
SupportsTransaction |
Specifies whether or not the database can be named in a transaction-based SQL statement. Set to true if it supports a transaction, otherwise set to false. |
|
SupportsTransactions |
Specifies whether or not the database can be named in multiple transaction-based SQL statements. Set to true if it supports transactions, otherwise set to false. |
|
TransactionIsoLevel |
Specifies the transaction isolation level. Isolation levels supported by BDP.NET include ReadCommitted, RepeatableRead, DirtyRead, and Custom. |
|
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
|
|
What do you think about this topic? Send feedback!
|
File