Oracle 5.0, Reference Manual

Page: 1920 / 3232

Connector/Net Programming
1900
•
GetSchema(String, String[])
- In this call the first string parameter represents the collection
name, and the second parameter represents a string array of restriction values. Restriction values
limit the amount of data that will be returned. Restriction values are explained in more detail in the
Microsoft .NET documentation .
20.2.5.2.3.1. Collections
The collections can be broadly grouped into two types: collections that are common to all data
providers, and collections specific to a particular provider.
Common
The following collections are common to all data providers:
• MetaDataCollections
• DataSourceInformation
• DataTypes
• Restrictions
• ReservedWords
Provider-specific
The following are the collections currently provided by MySQL Connector/Net, in addition to the
common collections above:
• Databases
• Tables
• Columns
• Users
• Foreign Keys
• IndexColumns
• Indexes
• Foreign Key Columns
• UDF
• Views
• ViewColumns
• Procedure Parameters
• Procedures
• Triggers
Example Code
A list of available collections can be obtained using the following code:
using System;
using System.Data;
using System.Text;
using MySql.Data;