G:\android\android-sdk_r07-windows\android-sdk-windows\tools>adb shell
# sqlite3 /data/data/com.android.deskclock/databases/alarms.db
sqlite3 /data/data/com.android.deskclock/databases/alarms.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
.table
alarms android_metadata
sqlite>
看见表了吧
sqlite> select * from alarms;
select * from alarms;
1|8|30|31|0|0|1|||10|0
2|9|0|96|0|0|1|||10|0
3|13|57|0|0|0|1||content://settings/system/alarm_alert|5|3
sqlite>
看看字段
sqlite> .schema
.schema
CREATE TABLE alarms (_id INTEGER PRIMARY KEY,hour INTEGER, minutes INTEGER, days
ofweek INTEGER, alarmtime INTEGER, enabled INTEGER, vibrate INTEGER, message TEX
T, alert TEXT, times INTEGER, interval INTEGER);
CREATE TABLE android_metadata (locale TEXT);
sqlite>
sqlite> .schema alarms
.schema alarms
CREATE TABLE alarms (_id INTEGER PRIMARY KEY,hour INTEGER, minutes INTEGER, days
ofweek INTEGER, alarmtime INTEGER, enabled INTEGER, vibrate INTEGER, message TEX
T, alert TEXT, times INTEGER, interval INTEGER);
sqlite>
# sqlite3 /data/data/com.android.deskclock/databases/alarms.db
sqlite3 /data/data/com.android.deskclock/databases/alarms.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
.table
alarms android_metadata
sqlite>
看见表了吧
sqlite> select * from alarms;
select * from alarms;
1|8|30|31|0|0|1|||10|0
2|9|0|96|0|0|1|||10|0
3|13|57|0|0|0|1||content://settings/system/alarm_alert|5|3
sqlite>
看看字段
sqlite> .schema
.schema
CREATE TABLE alarms (_id INTEGER PRIMARY KEY,hour INTEGER, minutes INTEGER, days
ofweek INTEGER, alarmtime INTEGER, enabled INTEGER, vibrate INTEGER, message TEX
T, alert TEXT, times INTEGER, interval INTEGER);
CREATE TABLE android_metadata (locale TEXT);
sqlite>
sqlite> .schema alarms
.schema alarms
CREATE TABLE alarms (_id INTEGER PRIMARY KEY,hour INTEGER, minutes INTEGER, days
ofweek INTEGER, alarmtime INTEGER, enabled INTEGER, vibrate INTEGER, message TEX
T, alert TEXT, times INTEGER, interval INTEGER);
sqlite>