Finding a Database's Structure

[Eric]

I'd like to write an app for testing how well my application works with a really large database. I also want to be able to use it again for other projects. Is it possible, once connected to a database, to get all the tables and the field type for each column? I'd like to display this to the user an allow them to generate random information of that type for each column.

[Miha Markic]

Hi Eric,

Yes, it is possible. One way is to use OleDbConnection.GetOleDbSchemaTable
method.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
..
"Eric" <an*******@discussions.microsoft.com> wrote in message
news:8F**********************************@microsof t.com...

I'd like to write an app for testing how well my application works with a

really large database. I also want to be able to use it again for other
projects. Is it possible, once connected to a database, to get all the
tables and the field type for each column? I'd like to display this to the
user an allow them to generate random information of that type for each
column.

[Paul Robson]

Eric wrote:

I'd like to write an app for testing how well my application works

with a really large database. I also want to be able to use it again
for other projects. Is it possible, once connected to a database,
to get all the tables and the field type for each column?
I'd like to display this to the user an allow them to generate
random information of that type for each column.

Not being totally up to speed on MSSQL stuff yet I can't say for sure,
but many SQL databases have tables with this data actually in them.