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 } |