GetOleDbSchemaTable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I using OleDbConnection.GetOleDbSchemaTable to read the database schema from
an access database.

The question is if I do the same operation on a different database provider
(for example sql server) will the tables/columns of the schema be the same ?

Thanks,
Rich.
 
Hi,

I think that the tables and column will be the same, but not the data inside
columns (some fields might have different values, for example Access has
some datatypes that SqlServer doesn't).
 
If you are attempting to find the schema of SQL Server you could always call
the stored procedures "sp_tables" and then "sp_columns" for each table. This
will give you all the info you need regarding the schema.
 
You must log in or register to reply here.

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 to read OleDbSchemaGuid tables 1 record at a time ? 17
schema compare problem 4
Schemas in ADO.Net 2.0 2
Retrieve the metadata of View dependents of sql server 2
How to detect MS Access lookup fields when querying schema 1
Is there any way to get database schema in generic way? 1
GetOleDbSchemaTable question 1
User default schema 1

Back
Top