table_with_compound_pk

Table actions

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

Link pk1 pk2 name
1,1 1 1 Row 1 1
1,2 1 2 Row 1 2
1,3 1 3 Row 1 3
1,4 1 4 Row 1 4
1,5 1 5 Row 1 5
1,6 1 6 Row 1 6
1,7 1 7 Row 1 7
2,1 2 1 Row 2 1
2,2 2 2 Row 2 2
2,3 2 3 Row 2 3
2,4 2 4 Row 2 4
2,5 2 5 Row 2 5
2,6 2 6 Row 2 6
2,7 2 7 Row 2 7
3,1 3 1 Row 3 1
3,2 3 2 Row 3 2
3,3 3 3 Row 3 3
3,4 3 4 Row 3 4
3,5 3 5 Row 3 5
3,6 3 6 Row 3 6
3,7 3 7 Row 3 7

Advanced export

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

CSV options: 

CREATE TABLE [table_with_compound_pk] (
   [pk1] INTEGER,
   [pk2] INTEGER,
   [name] TEXT,
   PRIMARY KEY ([pk1], [pk2])
);