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.
 
Back
Top