Solved

OpenSchema in VB .NET

Posted on 2006-11-21
5
694 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:knowlton
  • 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: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:knowlton
ID: 17992109
Thank you.
0
 
LVL 16

Expert Comment

by:Hillwaaa
ID: 17992113
No worries!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Form design in vb.net 7 34
VB.Net - For Loop Error 5 37
Change Format on Data when exporting to Excel 4 23
Advice in Xamarin 21 56
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now