Lines Matching defs:zTab
12600 ** Attempt to allocate an IdxTable structure corresponding to table zTab
12611 const char *zTab, /* Table name */
12625 if( zTab==0 ) return SQLITE_ERROR;
12626 nTab = STRLEN(zTab);
12628 rc = idxPrintfPrepareStmt(db, &p1, pzErrmsg, "PRAGMA table_xinfo=%Q", zTab);
12638 db, "main", zTab, zCol, 0, &zColSeq, 0, 0, 0
12671 db, "main", zTab, zCol, 0, &zColSeq, 0, 0, 0
12690 if( ALWAYS(pNew->zName!=0) ) memcpy(pNew->zName, zTab, nTab+1);
13219 const char *zTab = pTab->zName;
13229 rc = idxPrintfPrepareStmt(p->db, &pSelect, pzErr, zSql, zTab, zTab);
13239 char *z = sqlite3_mprintf("ALTER TABLE temp.%Q RENAME TO %Q", zTab, zInt);
13521 const char *zTab,
13552 "SELECT %s FROM %Q x ORDER BY %s", zCols, zTab, zOrder
13597 sqlite3_bind_text(pWriteStat, 1, zTab, -1, SQLITE_STATIC);
13618 static int idxBuildSampleTable(sqlite3expert *p, const char *zTab){
13626 "CREATE TABLE temp." UNIQUE_TABLE_NAME " AS SELECT * FROM %Q", zTab
13700 const char *zTab = (const char*)sqlite3_column_text(pAllIndex, 1);
13702 if( zTab==0 || zIdx==0 ) continue;
13708 rc = idxBuildSampleTable(p, zTab);
13711 rc = idxPopulateOneStat1(p, pIndexXInfo, pWrite, zTab, zIdx, pzErr);
16520 ** zTab:
16549 char *zTab; /* Name of table */
17538 pNew->zTab = csr = (char*)&pNew->aCol[nCol];
17774 zSql = recoverMPrintf(p, "INSERT OR IGNORE INTO %Q(", pTab->zTab);
17908 ** table in the output database. The name of the table is zTab, and it has
17913 const char *zTab,
17926 p, p->dbOut, "INSERT INTO %s VALUES(%s)", zTab, zBind
17935 p, p->dbOut, "SELECT 'INSERT INTO %s VALUES(' || %s || ')'", zTab, zBind
18098 char *zTab = 0; /* Name of lost_and_found table */
18100 zTab = recoverLostAndFoundCreate(p, pLaf->nMaxField);
18101 pLaf->pInsert = recoverLostAndFoundInsert(p, zTab, pLaf->nMaxField);
18102 sqlite3_free(zTab);
18213 if( sqlite3_stricmp("sqlite_sequence", p1->pTab->zTab)==0 ){
22463 ** columns in table zTab. The memory to hold the names is dynamically
22467 ** The azCol[0] entry is usually NULL. However, if zTab contains a rowid
22474 static char **tableColumnList(ShellState *p, const char *zTab){
22485 zSql = sqlite3_mprintf("PRAGMA table_info=%Q", zTab);
22530 " WHERE origin='pk'", zTab);
22556 rc = sqlite3_table_column_metadata(p->db,0,zTab,azRowid[j],0,0,0,0,0);
23231 static int session_filter(void *pCtx, const char *zTab){
23235 if( sqlite3_strglob(pSession->azFilter[i], zTab)==0 ) return 0;
25508 const char *zTab = 0; /* SQL table into which to insert */
25523 zTab = zTemp;
25526 zTab, pAr->zFile
25531 zTab = "zip";
25535 zTab = "sqlar";
25548 " AND mem.mode=disk.mode)", zTab);
25554 char *zSql2 = sqlite3_mprintf(zInsertFmt[pAr->bZip], zTab,
28655 const char *zTab = (const char*)sqlite3_column_text(pStmt,0);
28656 if( zTab==0 ) continue;
28657 if( zLike && sqlite3_strlike(zLike, zTab, 0)!=0 ) continue;
28658 if( cli_strncmp(zTab, "sqlite_",7)!=0 ){
28660 appendText(&sQuery,zTab,'"');
28662 }else if( cli_strcmp(zTab, "sqlite_schema")==0 ){
28665 }else if( cli_strcmp(zTab, "sqlite_sequence")==0 ){
28668 }else if( cli_strcmp(zTab, "sqlite_stat1")==0 ){
28671 }else if( cli_strcmp(zTab, "sqlite_stat4")==0 ){
28673 appendText(&sQuery, zTab, 0);
28680 appendText(&sSql, zTab, '\'');