Archives / 2005 / May
  • 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 :)