using System; using System.Data; using System.Data.Sql; using System.Data.SqlClient; class SQLDatabaseDiscovery { static void Main() { string strCon = @"server=.\sqlexpress;Database=AdventureWorks;Trusted_Connection=yes"; SqlConnection con = new SqlConnection(strCon); con.Open(); // Available schemas //DataTable schemas = con.GetSchema(); DataTable tables = con.GetSchema("Tables"); DataTable views = con.GetSchema("Views"); DataTable columns = con.GetSchema("Columns"); con.Close(); foreach (DataRow row in tables.Rows) { Console.WriteLine(row["table_name"]); } Console.WriteLine("Views in catalog:"); foreach (DataRow row in views.Rows) { Console.WriteLine(row["table_name"]); } Console.WriteLine("Column info in catalog:"); foreach (DataRow row in columns.Rows) { Console.WriteLine("{0}.{1}",row["table_name"],row["column_name"]); } } }Cetin