home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1683198740

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/585#issuecomment-1683198740 https://api.github.com/repos/simonw/sqlite-utils/issues/585 1683198740 IC_kwDOCGYnMM5kU5MU 9599 2023-08-18T01:26:47Z 2023-08-18T01:26:47Z OWNER

The only CLI feature that supports providing just the column name appears to be this: bash sqlite-utils add-foreign-key --help ``` Usage: sqlite-utils add-foreign-key [OPTIONS] PATH TABLE COLUMN [OTHER_TABLE] [OTHER_COLUMN]

Add a new foreign key constraint to an existing table

Example:

  sqlite-utils add-foreign-key my.db books author_id authors id

WARNING: Could corrupt your database! Back up your database file first. `` I can drop that WARNING now since I'm not writing tosqlite_master` any more.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
1855894222  
Powered by Datasette · Queries took 1.055ms · About: github-to-sqlite