System.Data.SQLite

Hi can anyone tell me if sqlite supports foreign key relationships? Im trying to make references to another table, but in create table i cant see any notion of foregin keys for fields. Or does the relationship purely exist when i defiene queries and the associated left joins etc.

Many thanks in advance,

Chris

SQLite allows you to define foreign key constraints in your table definition.  It currently doesn't enforce those constraints, but it does allow you to define them.

The SQLite provider will also parse them from the schema and fully report them so that the typed dataset designer will automatically generate the relationships when you drag and drop tables.

Robert