table_with_compound_pk

Table actions

7 rows where pk1 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

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

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])
);