How to read database metadata

  • Thread starter Thread starter Kari
  • Start date Start date
K

Kari

Hi

Is there an easy way of reading names of tables in a database? I would like
to read all user tables from a SQL Server database and show table names in
a list (to let user select which ones to export). I use C#, ADO.NET and SQL
Server.

-Kari

PS. I'm trying to change from Java to C# but I have problems with things
that I could easily do with Java and have no idea of how to do them in C#.
It's not as easy as I thought, at least not to me.
 
Hi Kari,

Another way (to what Jim suggested) would be to use
OleDbConnection.GetOleDbSchema method.
 
Back
Top