Local Relations

Besides the foreign key constrains on your back-end database, WinSQL allows you to create local relationships among tables. Local relationships are only available within WinSQL and does not rely on the foreign key constraints on the database.

With local relationships you can:

  • Define relationships on databases that do not support foreign keys, such as plain text files, or MS Excel spread sheets
  • Create new relationships besides the ones that already exists
Note that many database designers choose not to define foreign key constraints on their database even if their back-end RDBMS supports it. They do this to speed up the runtime environment. In such cases local relationships come in real handy.

Why are relationships important?

Many features in WinSQL rely on relationships among tables. For instance WinSQL can:


Social Media

Powered by