RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TDBXColumnsIndex Class

Accesses columns by ordinal in the Columns metadata.

Pascal
TDBXColumnsIndex = class;
C++
class TDBXColumnsIndex;

DBXMetaDataNames

TDBXColumnsIndex is used to access columns by ordinal in the Columns metadata collection. These columns are returned when TDBXCommand.Text' is TDBXMetaDataCommands.GetColumns when reading metadata. To retrieve metadata columns, use these constants to index the TDBXReader instance returned by TDBXCommand.ExecuteQuery. 

This table describes the columns.

Column Ordinal Name 
Data Type of Column Data 
Description 
String  
Catalog name.  
String  
Schema name.  
String  
Table name.  
String  
Column name.  
String  
Database specific data type name.  
Int32  
Precision of this type.
For a string data type, this is the maximum number of characters.
For a decimal types, this is the maximum number digits including digits from the scale.  
Scale  
Int32  
Scale of a decimal type.  
Int32  
Position in the rows of the table starting with 1.  
String  
Default value.  
Boolean  
True if accepts NULL values; false otherwise.  
Boolean  
Is an autoincrement value.  
Int32  
The maximal number of bytes to write into row. The rest of the data is handled as a BLOB. (Blackfish SQL only).  
Int32  
dbExpress data type.  
Boolean  
True if holds fixed length data; false otherwise.  
Boolean  
Can hold Unicode characters.  
IsLong  
Boolean  
Is a BLOB data type.  
Boolean  
Is an unsigned numeric type.  

 

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!