<div>
SqlConnection cn = new SqlConnection(&quot;PutYourConn<wbr />ectionStri<wbr />ngOverHere<wbr />&quot;);<br />
SqlDataAdapter da = new SqlDataAdapter(&quot;SELECT * FROM Information_Schema.Tables where Table_Type = 'BASE TABLE'&quot;, cn&quot;);<br />
DataTable dt = new DataTable();<br />
da.Fill(dt);<br />

</div>


SqlConnection cn = new SqlConnection("PutYourConnectionStringOverHere");
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Information_Schema.Tables where Table_Type = 'BASE TABLE'", cn");
DataTable dt = new DataTable();
da.Fill(dt);


<div>
<div class="content wysiwyg-content">
I would like to retrieve the database schema and determine the following:<br />
<br />
&nbsp; * User Tables<br />
&nbsp; * Keys (primary keys, composite keys, no keys)<br />
&nbsp; * Relationships (all types)<br />
&nbsp; * Null possible<br />
<br />
I am really desperate to retrieve this information and will award maximum points for solution.<br />
<br />
Can someone please provide an example of how to retrieve the schema and the above information.<br />
<br />
Cheers.
</div>
</div>


I would like to retrieve the database schema and determine the following:

  * User Tables
  * Keys (primary keys, composite keys, no keys)
  * Relationships (all types)
  * Null possible

I am really desperate to retrieve this information and will award maximum points for solution.

Can someone please provide an example of how to retrieve the schema and the above information.

Cheers.

MS SQL Server database schema retrieval

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).