The OleDbSchemaGuid class is used to specify the type of schema table used by the OleDbConnection.GetOleDbSchemaTable( ) method. This class is used to indicate the information you want to retrieve. For example, you can retrieve the tables in a database using code like this:

DataTable dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[  ]

    {null, null, null, "TABLE"});

After executing this code, the System.Data.DataTable object dt will contain a list of all tables in the current database. You can also retrieve information such as a list of views, stored procedures, constraints, keys, indexes, and so on by using a different OleDbSchemaGuid. Note that when you use a System.Data.DataSet, you can use the OleDbDataAdapter.FillSchema( ) method to retrieve some of the required schema information.

public sealed class OleDbSchemaGuid {

// Public Constructors

   public OleDbSchemaGuid( );  

// Public Static Fields

   public static readonly Guid Assertions;                     // =c8b52210-5cf3-11ce-ade5-00aa0044773d

   public static readonly Guid Catalogs;                       // =c8b52211-5cf3-11ce-ade5-00aa0044773d

   public static readonly Guid Character_Sets;                 // =c8b52212-5cf3-11ce-ade5-00aa0044773d

   public static readonly Guid Check_Constraints;              // =c8b52215-5cf3-11ce-ade5-00aa0044773d

   public static readonly Guid Check_Constraints_By_Table;     // =c8b52301-5cf3-11ce-ade5-00aa0044773d

   public static readonly Guid Collations;                     // =c8b52213-5cf3-11ce-ade5-00aa0044773d

   public static readonly Guid Column_Domain_Usage ...

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.