Equivalent of sys* tables of SQL Server in Access

When working with SQL Server it is easy to get access to database metadata like tables, stored procedures etc, by using the sys* tables. I was doing some work with Access and wanted to do something similar, turns out that it is quite easy to do.

Basically the OleDbCommand.GetOleDbSchemaTable() method allows you to get as much metadata you want about the DB.

Pretty obscure but a God send when you really need it :)

1 Comment

  • Very cool. And great timing... I was JUST about to have to do this very thing (query a MDB for tables/etc) today or tomorrow.



    Thanks for posting it!

Comments have been disabled for this content.