foreign_key_references

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

2 rows

View and edit SQL

pk foreign_key_with_label foreign_key_with_no_label
1 hello 1 1
2    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE foreign_key_references (
  pk varchar(30) primary key,
  foreign_key_with_label varchar(30),
  foreign_key_with_no_label varchar(30),
  FOREIGN KEY (foreign_key_with_label) REFERENCES simple_primary_key(id),
  FOREIGN KEY (foreign_key_with_no_label) REFERENCES primary_key_multiple_columns(id)
);
Powered by Datasette · Query took 9.871ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette