''OleDbSchemaGuid'' '''

OleDbSchemaGuid

System.Data.OleDb (system.data.dll) sealed class

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;            // =c8b5221b-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Column_Privileges;              // =c8b52221-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Columns;                        // =c8b52214-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Constraint_Column_Usage;        // =c8b52216-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Constraint_Table_Usage;         // =c8b52217-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid DbInfoLiterals;                 // =f3264c9d-1860-4dfe-b71b-2961b2ea91bd
   public static readonly Guid Foreign_Keys;                   // =c8b522c4-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Indexes;                        // =c8b5221e-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Key_Column_Usage;               // =c8b52218-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Primary_Keys;                   // =c8b522c5-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Procedure_Columns;              // =c8b522c9-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Procedure_Parameters;           // =c8b522b8-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Procedures;                     // =c8b52224-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Provider_Types;                 // =c8b5222c-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Referential_Constraints;        // =c8b52219-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Schemata;                       // =c8b52225-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Sql_Languages;                  // =c8b52226-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Statistics;                     // =c8b52227-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Table_Constraints;              // =c8b5221a-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Table_Privileges;               // =c8b52222-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Table_Statistics;               // =c8b522ff-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Tables;                         // =c8b52229-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Tables_Info;                    // =c8b522e0-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Translations;                   // =c8b5222a-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Trustee;                        // =c8b522ef-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Usage_Privileges;               // =c8b52223-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid View_Column_Usage;              // =c8b5222e-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid View_Table_Usage;               // =c8b5222f-5cf3-11ce-ade5-00aa0044773d
   public static readonly Guid Views;                          // =c8b5222d-5cf3-11ce-ade5-00aa0044773d
}


    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference
    Chapter 34. The System.Data Namespace
     
    ASPTreeView.com
     
    Evaluation has ВКґАР¶јexpired.
    Info...