Name
OleDbSchemaGuid
Synopsis
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.