the databases are not visible as files. although the explorer will show them in \My Computer\Mobile Device\My Pocket PC\Databases but you can only see them there.
every bit of data under Windows CE has an objectid, this includes:
files, directories, filedatablocks, registrykeys, registryvalues, databases,
database-records, database volumes
normally you are only able to 'see' the CEOID's of files, dirs, databases, and records.
several indices can be created for each database. these indices can be queried on equal, less, greater etc...
tip on how to change contacts sorting order here
oid 0d001ac8: dbase F00000017 T00000000 3 968 ... 'fldr1001adf' ORDERING: 0e060040:00000000 0c1a001f:00000002 0037001f:00000002 00090013:00000000 oid 02001af0: dbase F00000017 T00000000 0 272 ... 'fldr1001ae2' ORDERING: 0e060040:00000000 0c1a001f:00000002 0037001f:00000002 00090013:00000000 oid 02001ae7: dbase F00000017 T00000000 0 272 ... 'fldr1001a4b' ORDERING: 0e060040:00000000 0c1a001f:00000002 0037001f:00000002 00090013:00000000 oid 00001a53: dbase F00000017 T000352e0 0 272 ... '\MetabaseOptions' ORDERING: 00000013:00000000 oid 01001a24: dbase F00000017 T000352e0 0 272 ... '\MetabaseLabels' ORDERING: 00000013:00000000 oid 01001a44: dbase F00000017 T00000000 7 732 ... 'pmailNamedProps' ORDERING: 8300001f:00000000 oid 01001a41: dbase F00000017 T00000000 3 428 ... 'pmailMsgClasses' ORDERING: 8300001f:00000000 oid 00001a3e: dbase F00000017 T00000000 3 416 ... 'pmailServices' ORDERING: 8300001f:00000000 oid 00001a39: dbase F00000017 T00000000 3 452 ... 'pmailMsgs' ORDERING: 800c001f:00000000 0e090013:00000000 oid 00001a36: dbase F00000017 T00000000 14 1576 ... 'pmailFolders' ORDERING: 3001001f:00000002 0e090013:00000000 oid 00001a1e: dbase F00000017 T00000000 12 628 ... 'Status Store' ORDERING: 00010013:00000000 oid 01001100: dbase F00000017 T00000000 2 504 ... 'DB_notify_queue' ORDERING: 00010040:00000000 oid 000017aa: dbase F00000017 T00000000 6 808 ... 'clog.db' ORDERING: 00020040:00000001 oid 000017a8: dbase F00000017 T00000040 1 436 ... 'speed.db' ORDERING: 00020002:00000000 oid 000017a2: dbase F00000017 T0000001b 2 392 ... '\Categories Database' ORDERING: 4001001f:00000002 40020002:00000002 40030002:00000002 oid 0000179e: dbase F00000017 T00000018 0 272 ... 'Contacts Database' ORDERING: 4013001f:00000002 3a06001f:00000002 3a16001f:00000002 oid 0000179a: dbase F00000017 T0000001a 0 272 ... 'Tasks Database' ORDERING: 0037001f:00000002 410f0002:00000000 00260003:00000000 oid 00001796: dbase F00000017 T00000019 0 272 ... 'Appointments Database' ORDERING: 420d0040:00000000 42230002:00000000 42130003:00000000 oid 00001793: dbase F00000017 T42424242 0 272 ... '\DesktopPositions' ORDERING: 42010003:00000000 4204001f:00000000 oid 0000178c: dbase F00000017 T00000000 5 584 ... 'DB_notify_events' ORDERING: 0001001f:00000000 oid 00001655: dbase F00000017 T00000000 302 21512 ... '\ConfigMetabase' ORDERING: 0952001f:00000002 0f520013:00000001 oid 01001af5: dbase F00000017 T00000000 0 272 ... 'MailActiveSync' oid 00001a3c: dbase F00000017 T00000000 0 272 ... 'pmailOldTables'mail folders are databases named 'fldr*', and defined in the database 'pmailFolders'
0x1282 clog.db 0x0 13 1636 1
ORDERING:
0002:CEDB_SORT_DESCENDING [ startcall ]
0000215f ( 180 8 4)
0001 T02 L0001 F0000 I2 1 ?
0002 T40 L0006 F0000 FT 01c2ec999abca180 startcall
0003 T40 L0000 F0000 FT 01c2ec999f815580 endcall
0004 T03 L01c2 F0000 I4 6 calltype [4=missed, 5=outgoing, 6=incoming, 7=rejected]
0005
0006 T1f L01c2 F0000 STR [0014cb48](12) '+31612345678' number
0007 T1f L0000 F0000 STR [0014cb64]( 8) 'Lst, 1st' last,firstname
0008
0009 T03 L0074 F0000 I4 0 ?
000a T1f L0000 F0000 STR [0014cb78]( 1) 'm' numbertype
number types:
w work tel
m mobile tel
h home tel
pgr pager
car car tel
w2 work2 tel
h2 home2 tel
rdo radio tel
ast assistant tel
Oid Name DbType Records SrtOrdr
-----------------------------------------------------------------------------
0x1276 Contacts Database 0x18 1 936 3
ORDERING:
4013:CEDB_SORT_CASEINSENSITIVE [ lastname, firstname ]
3a06:CEDB_SORT_CASEINSENSITIVE [ firstname ]
3a16:CEDB_SORT_CASEINSENSITIVE [ company ]
060020f7 ( 1452 49 24)
0016 T41 L0000 F0000 BIN [0014d1b4] ( 4): 02 10 00 00 ?
0017 T41 L0074 F0000 BIN [0014d1b8] ( 8): 4e 6f 6f 74 0d 0a 0d 0a Notes
3a05 T1f L0069 F0000 STR [0014d1a0]( 3) '1st' suffix
3a06 T1f L0004 F0000 STR [0014d168]( 4) 'Test' firstname
3a08 T1f L0000 F0000 STR [0014d128]( 3) '121' work tel
3a09 T1f L0000 F0000 STR [0014d0c8]( 3) '124' home tel
3a11 T1f L0065 F0000 STR [0014d174]( 3) 'Est' lastname
3a16 T1f L0071 F0000 STR [0014d14c]( 7) 'Company' Company
3a17 T1f L0065 F0000 STR [0014d1a8]( 5) 'Title' Job title
3a18 T1f L45a6 F0000 STR [0014d15c]( 4) 'Dept' Department
3a19 T1f L0000 F0000 STR [0014d188](10) 'Office loc' Office loc
3a1c T1f L0000 F0000 STR [0014d0d8]( 3) '123' mobile tel
3a1d T1f L1570 F0000 STR [0014d0e8]( 3) '130' radio tel
3a1e T1f L0000 F0000 STR [0014d034]( 3) '126' car tel
3a24 T1f L0000 F0000 STR [0014d120]( 3) '122' work fax
3a25 T1f L0000 F0000 STR [0014d0c0]( 3) '127' home fax
3a2f T1f L0010 F0000 STR [0014d0d0]( 3) '129' home2 tel
4001 T40 L0000 F0000 FT 019a9011160a8180 birthday
4002 T1f L002d F0000 STR [0014d018]( 9) 'Assistant' assistant
4003 T40 L0007 F0000 FT 01be64c0072f6e80 anniversary
4004 T1f L006f F0000 STR [0014d02c]( 3) '131' assistant tel
4006 T1f L0000 F0000 STR [0014d03c](14) 'Child1, Child2' children
4007 T1f L0000 F0000 STR [0014d130]( 3) '128' work2 tel
4008 T1f L0010 F0000 STR [0014d100](15) 'http://www.home' Home page
4009 T1f L0000 F0000 STR [0014d0e0]( 3) '125' pager
400a T1f L156f F0000 STR [0014d0f0]( 7) 'Spouse ' Spouse
4013 T1f L1000 F0000 STR [0014d138]( 9) 'Est, Test' lastname, firstname
4023 T1f L0074 F0000 STR [0014d180]( 2) 'Mr' title
4024 T1f L003d F0000 STR [0014d17c]( 1) 'T' middle
4040 T1f L0070 F0000 STR [0014d1c0]( 9) 'Home Addr' Home addr
4041 T1f L0064 F0000 STR [0014d1d4]( 8) 'Hometown' Home city
4042 T1f L0022 F0000 STR [0014d1e8]( 6) 'Beiern' home state
4043 T1f L0072 F0000 STR [0014d1f8]( 7) '5 54467' home zip
4044 T1f Ld348 F0000 STR [0014d208]( 7) 'Germany' home country
4045 T1f L0079 F0000 STR [0014d218]( 9) 'Work Addr' work addr
4046 T1f L0000 F0000 STR [0014d22c]( 4) 'Work' work city
4047 T1f L0063 F0000 STR [0014d238]( 4) 'City' work state
4048 T1f L0000 F0000 STR [0014d244]( 5) '78666' work zip
4049 T1f L006c F0000 STR [0014d250]( 7) 'Belgium' work country
404a T1f L0070 F0000 STR [0014d260](10) 'Other Addr' other addr
404b T1f L0073 F0000 STR [0014d278]( 5) 'Other' other city
404c T1f L0074 F0000 STR [0014d284]( 4) 'City' other state
404d T1f L002d F0000 STR [0014d290]( 5) '45677' other zip
404e T1f Ld348 F0000 STR [0014d29c](11) 'Netherlands' other country
4083 T1f L0000 F0000 STR [0014d05c](14) 'email@xxxx.xom' E-mail
4093 T1f L23a0 F0000 STR [0014d07c](15) '2ndmail@wrt.com' 2nd email
40a3 T1f L0000 F0000 STR [0014d09c](17) '3rdmail@ghtnj.com' 3rd email
fffd T13 L0065 F0000 UI4 1 ?
fffe T13 L0000 F0000 UI4 1 ?
Oid Name DbType Records SrtOrdr
-----------------------------------------------------------------------------
0x127A \Categories Database 0x1B 4 536 3
0000127e ( 116 6 2)
4001 T1f L0001 F0000 STR [00145a88]( 8) 'Business'
4002 T02 L0006 F0000 I2 0
4003 T02 L00bc F0000 I2 1
4004 T02 L0001 F0000 I2 0
4005 T02 L0060 F0000 I2 0
4006 T02 L0001 F0000 I2 0
0900212e ( 116 6 10)
4001 T1f L0001 F0000 STR [00145a88]( 4) 'Cat2'
4002 T02 L0006 F0000 I2 2
4003 T02 L0002 F0000 I2 1
4004 T02 L0000 F0000 I2 0
4005 T02 L0060 F0000 I2 0
4006 T02 L0001 F0000 I2 0
0500214e ( 116 6 0)
4001 T1f L0001 F0000 STR [00145a88]( 9) 'Category1'
4002 T02 L0006 F0000 I2 1
4003 T02 L0074 F0000 I2 1
4004 T02 L0001 F0000 I2 1
4005 T02 L0060 F0000 I2 0
4006 T02 L0000 F0000 I2 0
0000127f ( 116 6 2)
4001 T1f L0001 F0000 STR [00145a88]( 8) 'Personal'
4002 T02 L0006 F0000 I2 12
4003 T02 L0074 F0000 I2 1
4004 T02 L0000 F0000 I2 1
4005 T02 L0060 F0000 I2 0
4006 T02 L0002 F0000 I2 0