241   const char *zTab,               /* Name of table to return details of */  in columnNames()  argument
261     pStmt = db_prepare("PRAGMA %s.index_list=%Q", zDb, zTab);  in columnNames()
291     pStmt = db_prepare("PRAGMA %s.table_info=%Q", zDb, zTab);  in columnNames()
298     pStmt = db_prepare("PRAGMA %s.table_info=%Q", zDb, zTab);  in columnNames()
307     assert( sqlite3_stricmp(zTab,"sqlite_schema")==0  in columnNames()
308             || sqlite3_stricmp(zTab,"sqlite_master")==0 );  in columnNames()
448 static void dump_table(const char *zTab, FILE *out){  in dump_table()  argument
449   char *zId = safeId(zTab); /* Name of the table */  in dump_table()
458   pStmt = db_prepare("SELECT sql FROM aux.sqlite_schema WHERE name=%Q", zTab);  in dump_table()
464     az = columnNames("aux", zTab, &nPk, 0);  in dump_table()
510                      zTab);  in dump_table()
523 static void diff_one_table(const char *zTab, FILE *out){  in diff_one_table()  argument
524   char *zId = safeId(zTab); /* Name of table (translated for us in SQL) */  in diff_one_table()
545     az = columnNames("aux",zTab, &nPk, 0);  in diff_one_table()
559   if( sqlite3_table_column_metadata(g.db,"aux",zTab,0,0,0,0,0,0) ){  in diff_one_table()
560     if( !sqlite3_table_column_metadata(g.db,"main",zTab,0,0,0,0,0,0) ){  in diff_one_table()
563         fprintf(out, "-- 2nd DB has no %s table\n", zTab);  in diff_one_table()
570   if( sqlite3_table_column_metadata(g.db,"main",zTab,0,0,0,0,0,0) ){  in diff_one_table()
573       fprintf(out, "-- 1st DB has no %s table\n", zTab);  in diff_one_table()
575       dump_table(zTab, out);  in diff_one_table()
579   az = columnNames("main", zTab, &nPk, 0);  in diff_one_table()
580   az2 = columnNames("aux", zTab, &nPk2, 0);  in diff_one_table()
593     dump_table(zTab, out);  in diff_one_table()
696     zTab, zTab);  in diff_one_table()
757     zTab, zTab);  in diff_one_table()
777 static void checkSchemasMatch(const char *zTab){  in checkSchemasMatch()  argument
780       " WHERE A.name=%Q AND B.name=%Q", zTab, zTab  in checkSchemasMatch()
784       runtimeError("schema changes for table %s", safeId(zTab));  in checkSchemasMatch()
787     runtimeError("table %s missing from one or both databases", safeId(zTab));  in checkSchemasMatch()
1185   const char *zTab,  in getRbudiffQuery()  argument
1198   strPrintf(pSql, " FROM aux.%Q AS n WHERE NOT EXISTS (\n", zTab);  in getRbudiffQuery()
1199   strPrintf(pSql, "    SELECT 1 FROM ", zTab);  in getRbudiffQuery()
1200   strPrintf(pSql, " main.%Q AS o WHERE ", zTab);  in getRbudiffQuery()
1214   strPrintf(pSql, " FROM main.%Q AS n WHERE NOT EXISTS (\n", zTab);  in getRbudiffQuery()
1215   strPrintf(pSql, "    SELECT 1 FROM ", zTab);  in getRbudiffQuery()
1216   strPrintf(pSql, " aux.%Q AS o WHERE ", zTab);  in getRbudiffQuery()
1249     strPrintf(pSql, "\nFROM main.%Q AS o, aux.%Q AS n\nWHERE ", zTab, zTab);  in getRbudiffQuery()
1259 static void rbudiff_one_table(const char *zTab, FILE *out){  in rbudiff_one_table()  argument
1275   checkSchemasMatch(zTab);  in rbudiff_one_table()
1279   azCol = columnNames("main", zTab, &nPK, &bOtaRowid);  in rbudiff_one_table()
1281     runtimeError("table %s has no usable PK columns", zTab);  in rbudiff_one_table()
1286   strPrintf(&ct, "CREATE TABLE IF NOT EXISTS 'data_%q'(", zTab);  in rbudiff_one_table()
1292   getRbudiffQuery(zTab, azCol, nPK, bOtaRowid, &sql);  in rbudiff_one_table()
1296   strPrintf(&insert, "INSERT INTO 'data_%q' (", zTab);  in rbudiff_one_table()
1371     strPrintf(&cnt, "INSERT INTO rbu_count VALUES('data_%q', %d);", zTab, nRow);  in rbudiff_one_table()
1390 static void summarize_one_table(const char *zTab, FILE *out){  in summarize_one_table()  argument
1391   char *zId = safeId(zTab); /* Name of table (translated for us in SQL) */  in summarize_one_table()
1408   if( sqlite3_table_column_metadata(g.db,"aux",zTab,0,0,0,0,0,0) ){  in summarize_one_table()
1409     if( !sqlite3_table_column_metadata(g.db,"main",zTab,0,0,0,0,0,0) ){  in summarize_one_table()
1411       fprintf(out, "%s: missing from second database\n", zTab);  in summarize_one_table()
1416   if( sqlite3_table_column_metadata(g.db,"main",zTab,0,0,0,0,0,0) ){  in summarize_one_table()
1418     fprintf(out, "%s: missing from first database\n", zTab);  in summarize_one_table()
1422   az = columnNames("main", zTab, &nPk, 0);  in summarize_one_table()
1423   az2 = columnNames("aux", zTab, &nPk2, 0);  in summarize_one_table()
1435     fprintf(out, "%s: incompatible schema\n", zTab);  in summarize_one_table()
1506           zTab, nUpdate, nInsert, nDelete, nUnchanged);  in summarize_one_table()
1581 static void changeset_one_table(const char *zTab, FILE *out){  in changeset_one_table()  argument
1583   char *zId = safeId(zTab);     /* Escaped name of the table */  in changeset_one_table()
1594   checkSchemasMatch(zTab);  in changeset_one_table()
1597   pStmt = db_prepare("PRAGMA main.table_info=%Q", zTab);  in changeset_one_table()
1689   fwrite(zTab, 1, strlen(zTab), out);  in changeset_one_table()
1937   char *zTab = 0;  in main()  local
1991         zTab = argv[++i];  in main()
1993           sqlite3_stricmp(zTab, "sqlite_schema")==0  in main()
1994           || sqlite3_stricmp(zTab, "sqlite_master")==0;  in main()
2017     cmdlineError("The --schema option is useless with --table %s .", zTab);  in main()
2057   if( zTab ){  in main()
2058     xDiff(zTab, out);  in main()