How to read database metadata

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kari - 23 Mar 2004 13:29 GMT

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.

Reply to this Message

Jim Hughes - 23 Mar 2004 15:49 GMT

sp_tables

or

select name from sysobjects where type='u'

> Hi
>
[quoted text clipped - 8 lines]
> 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.

Reply to this Message

Miha Markic [MVP C#] - 23 Mar 2004 18:08 GMT

Hi Kari,

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

Signature

Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

> Hi
>
[quoted text clipped - 8 lines]
> 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.

Reply to this Message

How to read database metadata

Free Magazines