David McDivitt <[EMAIL PROTECTED]> wrote: > The question I have is in regard to the iPhone note database. There's > a [Note] table and [note_bodies] table. The designer should have made > just one table since [Note] and [note_bodies] are one-to-one, but > didn't. The [note_bodies] table has an integer [note_id] field, but > the [Note] table has no key or ID field to tie the records together. > A delete trigger exists on the [Note] table containing: > > CREATE TRIGGER delete_note_bodies AFTER DELETE ON Note > BEGIN > DELETE FROM note_bodies WHERE note_id = OLD.ROWID; > END; > COMMIT; > > This would seem to inply there's a hidden or implied column named > [ROWID] in the [Note] table.
http://sqlite.org/lang_createtable.html Search this page for ROWID. Igor tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
