Oracle Metadata

浏览数：24 / 时间：2015年06月12日

http://www.devart.com/dotconnect/oracle/articles/metadata.html
http://dcx.sybase.com/1101/en/dbprogramming_en11/ianywhere-data-sqlanywhere-saconnection-getschem6330755502-0.html

In this overload first parameter is name of a collection, and second parameter is the array of restrictions to be applied when querying information. Quantity of elements in the array must be less or equal to the value that is returned by GetSchema() method in the second cell of the row that corresponds to the collection name. (Or from the table below, which is much more handy.) If the second argument is null (Nothing), the function behaves like the previous overload (that takes a single parameter).
GetSchema Method Reference

Collection Name	Number of restrictions	Remarks
MetaDataCollections	0	Returns this list. Same as using GetSchema() method without parameters.
ReservedWords	0	Lists all reserved words used in the server.
Users	1	Lists all users on the server. When restricted by username, returns information about specific user.
Tables	2	GetSchema("Tables") Returns the list of all tables on the server that you have access to. The first restriction for this collection is name of a schema. If specified, the method returns all tables within the schema. The second restriction is table name. Note that masks are not allowed in dotConnect for Oracle.
Views	2	GetSchema("Views") Returns the list of all views on the server that you have access to. The first restriction for this collection is name of a schema. If specified, the method returns all views within the schema. The second restriction is the name of the view.
Columns	3	Returns the list of columns, their type and some extra information. GetSchema("Columns") Returns the list of all columns in all schemas of the table. Restricted by schema name, the method returns all columns in the specified schema. The second restriction is name of a table that GetSchema method should search in. At last, you can specify column name.
Indexes	4	Returns the list of indexes and their details. The first restriction is name of a schema the indexes belongs to. The second restriction is name of the index. The third restriction is name of a table that uses the index. The last restriction is name of schema the table belongs to.
IndexColumns	5	Returns information about columns included in indexes. The following restrictions may be specified: Name of the schema for indexes; Index name; Name of the schema for tables; Table name; Column name.
Functions	2	Returns the list of functions on the server. The following restrictions may be specified: Schema name; Function name.
Procedures	3	Returns the list of procedures on the server. The following restrictions may be specified: Schema name; Package name; Procedure name.
Arguments	4	Returns the list of procedure and function arguments. The following restrictions may be specified: Schema name; Package name; Procedure name; Argument name.
Synonyms	2	Returns the list of synonyms on the server. The following restrictions may be specified: Schema name; Synonym name.
Sequences	2	Returns the list of sequences on the server. The following restrictions may be specified: Schema name; Sequence name.
Packages	2	Returns the list of packages on the server. The following restrictions may be specified: Schema name; Package name.
PackageBodies	2	Returns the list of package bodies on the server that you have access to. The following restrictions may be specified: Schema name; Package name.
ForeignKeys	3	Returns the list of foreign keys on the server. The following restrictions may be specified: Schema name; Key name; Table name.
ForeignKeyColumns	3	Returns the list of columns of foreign keys on the server. The following restrictions may be specified: Schema name; Key name; Table name.
Triggers	2	Returns the list of triggers on the server that you have access to. The following restrictions may be specified: Schema name; Trigger name.
Clusters	2	Returns the list of clusters on the server that you have access to. The following restrictions may be specified: Schema name; Cluster name.