Finding a Database's Structure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
I'd like to write an app for testing how well my application works with a
Click to expand...
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.
 
Eric said:
I'd like to write an app for testing how well my application works
Click to expand...
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.
 
Back
Top