Category: Keys

SQLite Foreign Key is used to specify that values in one table also appear in another table. It enforces referential integrity within SQLite database. The referenced table is known as parent table while the table with the foreign key is known as child table. The foreign key in the child table will generally reference a…

SQLite primary key is a simple field or a combination of fields which is used to uniquely define a record. A table can have only one primary key. A primary key should not be a NULL value. Create Primary Key Primary key is generally created at the time of creating the table. We define the…