GetSchema from multiple tables

B

banana boy

I'm using .net 2 and the getschema function to get database schema.
This is the code i'm using to get the schema. How do i get schema for
multiple tables at once using the same code

restrictions(0) = database
restrictions(1) = owner
restrictions(2) = table

newTable = dbConnection.GetSchema("columns", restrictions)
 
M

Miha Markic [MVP C#]

Hi there,

I am not 100% sure but I don't think you can filter per more tables.
Thus omit restriction(2) and filter data on client.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does GetSchema get foreign key constraints? 4
GetSchema( "Columns" ) results in ??? 6
How to get meta data info in ADO.NET 2
Geting tables from an MDB file 1
How do I get all FK:PK mappings with the schema info? 8
How do I get all column descriptions from a schema.table? 7
How To Retrieve Database Schema? 4
The Microsoft Jet database engine could not find the object 'Sheet 8

Top