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  } 


ADO. NET in a Nutshell
ADO.NET in a Nutshell
ISBN: 0596003617
EAN: 2147483647
Year: 2005
Pages: 415

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net