Sqlite primary key on multiple columns

by

According to the documentation, it’s

CREATE TABLE something (
  column1, 
  column2, 
  column3, 
  PRIMARY KEY (column1, column2)
);

More Related Contents:

  1. How do I DROP a constraint from a sqlite (3.6.21) table?
  2. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  3. How do I unlock a SQLite database?
  4. “Insert if not exists” statement in SQLite
  5. Can I have multiple primary keys in a single table?
  6. How to delete or add column in SQLITE?
  7. How to get Top 5 records in SqLite?
  8. Insert new column into table in sqlite?
  9. How do you enable LIMIT for DELETE in SQLite?
  10. SQLite Schema Information Metadata
  11. How to create custom functions in SQLite
  12. Sqlite group_concat ordering
  13. Why use multiple columns as primary keys (composite primary key)
  14. is there a limit to the size of a SQLite database?
  15. How to generate all dates between two dates
  16. Does it matter what extension is used for SQLite database files?
  17. How do I add a new column in between two columns?
  18. Creating stored procedure and SQLite?
  19. How Scalable is SQLite? [closed]
  20. Are there any reserved words in SQLite?
  21. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  22. Modify a Column’s Type in sqlite3
  23. Case sensitive and insensitive like in SQLite
  24. SQLite accent-insensitive search
  25. How to have an automatic timestamp in SQLite?
  26. SELECT INTO statement in sqlite
  27. How to display blob value using x’abc’ binary string literal syntax?
  28. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  29. Drop column from SQLite table
  30. DbFunctions.TruncateTime LINQ equivalent in EF CORE

Leave a Comment