In Microsoft SQL Server, for example, a primary key usually equates to a clustered index. In SQLite, a primary key is usually just a unique index and is distinct from the special rowid column name.

MySQL table primary keys and unique indexes prevent multiple rows with the same index from being added to the table. If you try to insert a duplicate row with a standard INSERT statement, you will ...