Getting database info for SQL

[Sylvain Provencher]

Hi!

There is a way to obtain tables and fields info from an SQL connection. like
tables name, fields name, type and width ?

I'm writing a VB.NET application.

Thanks

[William Ryan]

What DB are you using? If it's sql server you can use Information_Schema
and find out just about anything. if you fire a query and use a DataReader,
you can also use GetSchemaTable for instance to get most of what you want
regarding individual tables.

HTH,

BIll
"Sylvain Provencher" <sy****************@nobelia.com> wrote in message
news:uI**************@TK2MSFTNGP09.phx.gbl...

Hi!

There is a way to obtain tables and fields info from an SQL connection. like tables name, fields name, type and width ?

I'm writing a VB.NET application.

Thanks

[Sylvain Provencher]

Actually, I use MS SQL server. I don't use a data reader, but it can be a
way...

Can you send me code snippet if you have it ? Thanks!

"William Ryan" <do********@comcast.nospam.net> wrote in message
news:un**************@TK2MSFTNGP11.phx.gbl...

What DB are you using? If it's sql server you can use Information_Schema
and find out just about anything. if you fire a query and use a DataReader, you can also use GetSchemaTable for instance to get most of what you want
regarding individual tables.

[William Ryan]

DataTable dt = new DataTable();

dt = myDataReader.GetScehmaTable();

Querying Information_Schema can do a lot for you too, check out BOL, there's
a bunch of info in there.

HTH,

Bill
"Sylvain Provencher" <sy****************@nobelia.com> wrote in message
news:O5**************@tk2msftngp13.phx.gbl...

Actually, I use MS SQL server. I don't use a data reader, but it can be a
way...

Can you send me code snippet if you have it ? Thanks!

"William Ryan" <do********@comcast.nospam.net> wrote in message
news:un**************@TK2MSFTNGP11.phx.gbl...

What DB are you using? If it's sql server you can use Information_Schema and find out just about anything. if you fire a query and use a

DataReader,

you can also use GetSchemaTable for instance to get most of what you want regarding individual tables.