469,282 Members | 1,671 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Finding a Database's Structure

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.
Nov 15 '05 #1
2 1038
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.
Nov 15 '05 #2
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.

Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jay Bienvenu | last post: by
2 posts views Thread by B Moor | last post: by
9 posts views Thread by Peter Duniho | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.