| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|---|
Retrieving database schema information |
Learn about using Microsoft SqlClient Data Provider for SQL Server to retrieve database schema information. |
David-Engel |
v-davidengel |
v-chmalh |
11/26/2020 |
sql |
connectivity |
conceptual |
[!INCLUDEappliesto-netfx-netcore-netst-md]
[!INCLUDEDriver_ADONET_Download]
Obtaining schema information from a database is accomplished with the process of schema discovery. Schema discovery allows applications to request that managed providers find and return information about the database schema, also known as metadata, of a given database. Different database schema elements such as tables, columns, and stored-procedures are exposed through schema collections. Each schema collection contains a variety of schema information specific to the provider being used.
The Microsoft SqlClient Data Provider for SQL Server implements the GetSchema method in the SqlConnection class, and the schema information that is returned from the GetSchema method comes in the form of a xref:System.Data.DataTable. The GetSchema method is an overloaded method that provides optional parameters for specifying the schema collection to return, and restricting the amount of information returned. The SqlClient data provider also provides a GetSchemaTable method that returns a DataTable describing the column metadata of the SqlDataReader.
GetSchema and schema collections
Describes the GetSchema method and how it can be used to retrieve and restrict schema information from a database.
Schema restrictions
Describes schema restrictions that can be used with GetSchema.
Common schema collections
Describes all of the common schema collections supported by all of the .NET managed providers.
SQL Server schema collections
Describes the additional schema collections supported by the Microsoft SqlClient Data Provider for SQL Server.
xref:System.Data.Common.DbConnection.GetSchema%2A
Describes the GetSchema method of the xref:System.Data.Common.DbConnection class.
xref:Microsoft.Data.SqlClient.SqlConnection.GetSchema%2A
Describes the GetSchema method of the xref:Microsoft.Data.SqlClient.SqlConnection class.
xref:System.Data.Common.DbDataReader.GetSchemaTable%2A
Describes the GetSchemaTable method of the xref:System.Data.Common.DbDataReader class.
xref:Microsoft.Data.SqlClient.SqlDataReader.GetSchemaTable%2A
Describes the GetSchemaTable method of the xref:Microsoft.Data.SqlClient.SqlDataReader class.