Get all table names : Table Schema « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. Table Schema

Get all table names

using System;
using System.Data;
using System.Data.OleDb;

public class DatabaseInfo {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();  
   Console.WriteLine("Made the connection to the database");

   Console.WriteLine("Information for each table contains:");
   DataTable tables = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[]{null,null,null,"TABLE"});

   Console.WriteLine("The tables are:");
   foreach(DataRow row in tables.Rows) 
     Console.Write("  {0}", row[2]);


   con.Close();
 }
}
 
           
       

Related examples in the same category

1.	Get specified column data type and column name from OleDbSchemaTable
2.	Get Column data type and name from DataColumn
3.	Read schema information using the FillSchema() method of a DataAdapter object
4.	How to read a table schema
5.	Get table Schema