Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

OpenSchema in VB .NET

Posted on 2006-11-21
5
Medium Priority
?
742 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
  • 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

572 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