patrick

patrick

  • NA
  • 397
  • 0

Check table Schema

Jun 23 2009 12:21 PM
Using ADODB.Connection of type Provider=Microsoft.Jet.OLEDB.4.0
I want to check to be sure database information is correct.

i.e. for each table that should be in the database, i want to check to be sure the table exists, each column that should be in the table is there, and that each column has the correct data type.
Im not sure how to programatically do this, and especially not sure how to do this without comprimising existing data.
if someone can point me to the proper sql commands that would be great. Thanks