Solved

OpenSchema in VB .NET

Posted on 2006-11-21
5
723 Views
Last Modified: 2008-03-03
Does anyone have some sample VB .NET code that shows how to use OpenSchema?


My intent is to ask a database what tables are inside of it.

Then to take that list of tables and ask each table what the column names are that it has.
0
Comment
Question by:Tom Knowlton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:Hillwaaa
ID: 17990848
Hi knowlton,

Are you using this for an Analysis Services cube?  If not I'm not sure if OpenSchema is what you want.

If you just want a list of all tables in the (assuming SQL Server 2000) database, use:

select name, id from sysobjects where xtype = 'U'  

then to get all of the column names, use:

select name from syscolumns where id = <id from previous query>


Cheers,
Hillwaaa
0
 
LVL 5

Author Comment

by:Tom Knowlton
ID: 17990857
What about if it is an MS Acess MDB file?
0
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 500 total points
ID: 17990906
knowlton,

Then I'd suggest looking at the code here: http://www.freevbcode.com/ShowCode.asp?ID=3884

It's VB6 but should be fairly easy to translate to VB .NET, and contains an example on using OpenSchema :)
0
 
LVL 5

Author Comment

by:Tom Knowlton
ID: 17992109
Thank you.
0
 
LVL 16

Expert Comment

by:Hillwaaa
ID: 17992113
No worries!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question