SELECT * FROM sqlite_master where type='table'

Directly from the tables in the location file on an iPad, latest IOS

sqlite> .mode column
sqlite> SELECT * FROM sqlite_master where type='table';
table       TableInfo   TableInfo   2           CREATE TABLE TableInfo (TableName TEXT, SoftwareVersion TEXT, SerialNumber TEXT, PRIMARY KEY (TableName))
table       Fences      Fences      4           CREATE TABLE Fences (BundleId TEXT, Name TEXT, Timestamp FLOAT, Latitude FLOAT, Longitude FLOAT, Distance
table       CompassCal  CompassCal  6           CREATE TABLE CompassCalibration (Timestamp FLOAT, MagneticX FLOAT, MagneticY FLOAT, MagneticZ FLOAT, Bias
table       CellLocati  CellLocati  7           CREATE TABLE CellLocation (MCC INTEGER, MNC INTEGER, LAC INTEGER, CI INTEGER, Timestamp FLOAT, Latitude F
table       CellLocati  CellLocati  13          CREATE TABLE CellLocationLocal (MCC INTEGER, MNC INTEGER, LAC INTEGER, CI INTEGER, Timestamp FLOAT, Latit
table       CellLocati  CellLocati  0           CREATE VIRTUAL TABLE CellLocationLocalBoxes USING rtree(ROWID, MinimumLatitude, MaximumLatitude, MinimumL
table       CellLocati  CellLocati  16          CREATE TABLE "CellLocationLocalBoxes_node"(nodeno INTEGER PRIMARY KEY, data BLOB)
table       CellLocati  CellLocati  17          CREATE TABLE "CellLocationLocalBoxes_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
table       CellLocati  CellLocati  18          CREATE TABLE "CellLocationLocalBoxes_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
table       Location    Location    19          CREATE TABLE Location (Timestamp FLOAT, Latitude FLOAT, Longitude FLOAT, HorizontalAccuracy FLOAT, Lifesp
table       Wifi        Wifi        23          CREATE TABLE Wifi (Timestamp FLOAT, MAC TEXT, RSSI INTEGER, PRIMARY KEY (Timestamp, MAC))
table       Cell        Cell        25          CREATE TABLE Cell (Timestamp FLOAT, MCC INTEGER, MNC INTEGER, LAC INTEGER, CI INTEGER, PRIMARY KEY (Times
table       WifiLocati  WifiLocati  31          CREATE TABLE WifiLocation (MAC TEXT, Timestamp FLOAT, Latitude FLOAT, Longitude FLOAT, HorizontalAccuracy
table       CellLocati  CellLocati  57          CREATE TABLE CellLocationHarvest (MCC INTEGER, MNC INTEGER, LAC INTEGER, CI INTEGER, RSSI INTEGER, ARFCN
table       CdmaCellLo  CdmaCellLo  248         CREATE TABLE CdmaCellLocationHarvest (MCC INTEGER, MNC INTEGER, SID INTEGER, NID INTEGER, BSID INTEGER, B
table       CdmaCellLo  CdmaCellLo  269         CREATE TABLE CdmaCellLocationHarvestCounts (Count INTEGER)
table       CdmaCellLo  CdmaCellLo  270         CREATE TABLE CdmaCellLocationLocal (MCC INTEGER, SID INTEGER, NID INTEGER, BSID INTEGER, ZONEID INTEGER,
table       CdmaCellLo  CdmaCellLo  272         CREATE TABLE CdmaCellLocationLocalCounts (Count INTEGER)
table       CdmaCellLo  CdmaCellLo  0           CREATE VIRTUAL TABLE CdmaCellLocationLocalBoxes USING rtree(ROWID, MinimumLatitude, MaximumLatitude, Mini
table       CdmaCellLo  CdmaCellLo  273         CREATE TABLE "CdmaCellLocationLocalBoxes_node"(nodeno INTEGER PRIMARY KEY, data BLOB)
table       CdmaCellLo  CdmaCellLo  274         CREATE TABLE "CdmaCellLocationLocalBoxes_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
table       CdmaCellLo  CdmaCellLo  275         CREATE TABLE "CdmaCellLocationLocalBoxes_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
table       CdmaCellLo  CdmaCellLo  276         CREATE TABLE CdmaCellLocation (MCC INTEGER, SID INTEGER, NID INTEGER, BSID INTEGER, ZONEID INTEGER, BANDC
table       CdmaCellLo  CdmaCellLo  279         CREATE TABLE CdmaCellLocationCounts (Count INTEGER)
table       CdmaCellLo  CdmaCellLo  0           CREATE VIRTUAL TABLE CdmaCellLocationBoxes USING rtree(ROWID, MinimumLatitude, MaximumLatitude, MinimumLo
table       CdmaCellLo  CdmaCellLo  280         CREATE TABLE "CdmaCellLocationBoxes_node"(nodeno INTEGER PRIMARY KEY, data BLOB)
table       CdmaCellLo  CdmaCellLo  281         CREATE TABLE "CdmaCellLocationBoxes_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
table       CdmaCellLo  CdmaCellLo  282         CREATE TABLE "CdmaCellLocationBoxes_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
table       WifiLocati  WifiLocati  10          CREATE TABLE WifiLocationCounts (Count INTEGER)
table       CellLocati  CellLocati  11          CREATE TABLE CellLocationHarvestCounts (Count INTEGER)
table       WifiLocati  WifiLocati  12          CREATE TABLE WifiLocationHarvest (MAC TEXT, Channel INTEGER, Hidden INTEGER, RSSI INTEGER, Age FLOAT, Bun
table       WifiLocati  WifiLocati  30          CREATE TABLE WifiLocationHarvestCounts (Count INTEGER)
table       LocationHa  LocationHa  42          CREATE TABLE LocationHarvest (Timestamp FLOAT, Latitude FLOAT, Longitude FLOAT, HorizontalAccuracy FLOAT,
table       LocationHa  LocationHa  44          CREATE TABLE LocationHarvestCounts (Count INTEGER)
table       CellLocati  CellLocati  15          CREATE TABLE CellLocationLocalCounts (Count INTEGER)
table       CellLocati  CellLocati  9           CREATE TABLE CellLocationCounts (Count INTEGER)
table       CellLocati  CellLocati  0           CREATE VIRTUAL TABLE CellLocationBoxes USING rtree(ROWID, MinimumLatitude, MaximumLatitude, MinimumLongit
table       CellLocati  CellLocati  63          CREATE TABLE "CellLocationBoxes_node"(nodeno INTEGER PRIMARY KEY, data BLOB)
table       CellLocati  CellLocati  64          CREATE TABLE "CellLocationBoxes_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
table       CellLocati  CellLocati  65          CREATE TABLE "CellLocationBoxes_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
sqlite>