http://www.devart.com/dotconnect/db2/docs/MetaData.html
Collection Name
| Number of restrictions |
Remarks
|
---|---|---|
MetaDataCollections | 0 |
Returns this list. Same as using GetSchema() method without parameters.
|
Restrictions | 0 |
Lists restrictions for each metadata collection.
|
ReservedWords | 0 |
Lists all reserved words used in the server.
|
DataSourceInformation | 0 |
Returns the information about the data source, associated with this DB2Connection instance.
|
DataTypes | 0 |
Lists data types supported by DB2 server.
|
Catalogs | 0 |
Lists databases on the DB2 server.
|
Schemas | 0 |
Lists schemas on the DB2 server.
|
Tables | 4 |
GetSchema("Tables") returns the list of all tables (and/or views) on the server that you have access to.
|
TablePrivileges | 3 |
GetSchema("Views") returns the list of table privileges on the server that you have access to.
|
Columns | 4 |
Returns the list of columns, their type and some extra information.
GetSchema("Columns") returns the list of all columns in all databases on the server you have access to.
|
Column Privileges | 4 |
Returns the list of column privileges.
GetSchema("Column Privileges") returns the list of column privileges in all databases on the server you have access to.
|
Indexes | 5 |
Returns the list of indexes and their details.
|
Functions | 3 |
Returns the list of functions on the server. The following restrictions may
be specified:
|
Procedures | 4 |
Returns the list of procedures on the server. The following restrictions
may be specified:
|
Function Parameters | 4 |
Returns the list of function arguments. The following restrictions may be
specified:
|
Procedure Parameters | 5 |
Returns the list of procedure arguments. The following restrictions may be
specified:
|
PrimaryKeys | 4 |
Returns the list of primary keys on the server. The following restrictions
may be specified:
|
ForeignKeys | 6 |
Returns the list of foreign keys on the server. The following restrictions
may be specified:
|
原文:http://www.cnblogs.com/geovindu/p/4362415.html