static void MetaCollections() { using (SqlDatabaseConnection cnn = new SqlDatabaseConnection("uri=@memory")) { cnn.Open(); //Available Meta Data Collections in this connection. // Let's use foreach loop to get all the meta collections foreach (DataRow r in cnn.GetSchema("METADATACOLLECTIONS").Rows) { if (r["NumberOfRestrictions"].Equals(0)) { Console.WriteLine(); Console.WriteLine("Starting... {0}", r["CollectionName"].ToString()); Console.WriteLine(); //Load another datatable CollectionDT with values DataTable CollectionDT = cnn.GetSchema(r["CollectionName"].ToString()); foreach (DataColumn column in CollectionDT.Columns) { Console.Write(column.ColumnName + "\t"); } Console.WriteLine(Environment.NewLine); foreach (DataRow row in CollectionDT.Rows) { foreach (DataColumn column in CollectionDT.Columns) { Console.Write(row[column.ColumnName] + "\t"); } Console.WriteLine(); } } } } }