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: