[Sample Of Mar 4th] How to Get Schema Information from Database

 

Sample Download : https://code.msdn.microsoft.com/How-to-Get-Schema-b66d62e2

Sometimes we may need the schema information of the database, tables or some columns. In this application, we will demonstrate how to get schema information from database:

1. In this application, we will use the SqlConnection.GetSchema Method.

2. We will use the Schema Restrictions to get the specified information.

3. We will get the schema information of the database, tables, some columns and so on.

You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place, and automatically be notified about sample updates. If it is the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on Microsoft Showcase, or read the introduction on our homepage https://1code.codeplex.com/.