databaseodbcschemasage-line-50

Sage 50 Accounts Database Schema

I am accessing Sage 50 data via their ODBC Driver but cannot seem to establish if the tables have a unique / primary key. The ODBC.NET Driver does not seem to return any information relating to indexes or key field information.

Anyone got any clues?

Tim

Solution

  • Tables ending in "m" seem to be master tables with actual real data in...

    Don't know if that helps at all.