你的位置:首页 > 数据库

[数据库]Oracle Metadata


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 NameNumber of restrictionsRemarks
MetaDataCollections0
Returns this list. Same as using GetSchema() method without parameters.
ReservedWords0
Lists all reserved words used in the server.
Users1
Lists all users on the server.
When restricted by username, returns information about specific user.
Tables2
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.
Views2
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.
Columns3
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.
Indexes4
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.
IndexColumns5
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.
Functions2
Returns the list of functions on the server. The following restrictions may be specified:
Schema name;
Function name.
Procedures3
Returns the list of procedures on the server. The following restrictions may be specified:
Schema name;
Package name;
Procedure name.
Arguments4
Returns the list of procedure and function arguments. The following restrictions may be specified:
Schema name;
Package name;
Procedure name;
Argument name.
Synonyms2
Returns the list of synonyms on the server. The following restrictions may be specified:
Schema name;
Synonym name.
Sequences2
Returns the list of sequences on the server. The following restrictions may be specified:
Schema name;
Sequence name.
Packages2
Returns the list of packages on the server. The following restrictions may be specified:
Schema name;
Package name.
PackageBodies2
Returns the list of package bodies on the server that you have access to. The following restrictions may be specified:
Schema name;
Package name.
ForeignKeys3
Returns the list of foreign keys on the server. The following restrictions may be specified:
Schema name;
Key name;
Table name.
ForeignKeyColumns3
Returns the list of columns of foreign keys on the server. The following restrictions may be specified:
Schema name;
Key name;
Table name.
Triggers2
Returns the list of triggers on the server that you have access to. The following restrictions may be specified:
Schema name;
Trigger name.
Clusters2
Returns the list of clusters on the server that you have access to. The following restrictions may be specified:
Schema name;
Cluster name.