foreign_key_references

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 8.642ms