Retrieving Tables with a Named Schema
The following is an example of how to retrieve the tables where the schema name is a fixed value like Mytest.
public void TestGetTablesInfo()
{
CompositeConnection conn = GetConnection();
try
{
string[] res = new string[4];
res[1] = "Mytest";
res[3] = "Table";
DataTable dt = conn.GetSchema("Tables",res);
foreach (DataRow myRow in dt.Rows)
{
Console.WriteLine(myRow["table_name"]);
}
}
catch (Exception ex)
{
throw ex;
}
}