Lines Matching refs:Table
2838 #define SQLITE_CREATE_INDEX 1 /* Index Name Table Name */
2839 #define SQLITE_CREATE_TABLE 2 /* Table Name NULL */
2840 #define SQLITE_CREATE_TEMP_INDEX 3 /* Index Name Table Name */
2841 #define SQLITE_CREATE_TEMP_TABLE 4 /* Table Name NULL */
2842 #define SQLITE_CREATE_TEMP_TRIGGER 5 /* Trigger Name Table Name */
2844 #define SQLITE_CREATE_TRIGGER 7 /* Trigger Name Table Name */
2846 #define SQLITE_DELETE 9 /* Table Name NULL */
2847 #define SQLITE_DROP_INDEX 10 /* Index Name Table Name */
2848 #define SQLITE_DROP_TABLE 11 /* Table Name NULL */
2849 #define SQLITE_DROP_TEMP_INDEX 12 /* Index Name Table Name */
2850 #define SQLITE_DROP_TEMP_TABLE 13 /* Table Name NULL */
2851 #define SQLITE_DROP_TEMP_TRIGGER 14 /* Trigger Name Table Name */
2853 #define SQLITE_DROP_TRIGGER 16 /* Trigger Name Table Name */
2855 #define SQLITE_INSERT 18 /* Table Name NULL */
2857 #define SQLITE_READ 20 /* Table Name Column Name */
2860 #define SQLITE_UPDATE 23 /* Table Name Column Name */
2863 #define SQLITE_ALTER_TABLE 26 /* Database Name Table Name */
2865 #define SQLITE_ANALYZE 28 /* Table Name NULL */
2866 #define SQLITE_CREATE_VTABLE 29 /* Table Name Module Name */
2867 #define SQLITE_DROP_VTABLE 30 /* Table Name Module Name */
5124 ** CAPI3REF: Extract Metadata About A Column Of A Table
5188 const char *zTableName, /* Table name */
5307 ** CAPI3REF: Virtual Table Object
5358 ** CAPI3REF: Virtual Table Indexing Information
5418 } *aConstraint; /* Table of WHERE clause constraints */
5437 ** CAPI3REF: Virtual Table Constraint Operator Codes
5452 ** CAPI3REF: Register A Virtual Table Implementation
5491 ** CAPI3REF: Virtual Table Instance Object
5516 ** CAPI3REF: Virtual Table Cursor Object
5538 ** CAPI3REF: Declare The Schema Of A Virtual Table
5548 ** CAPI3REF: Overload A Function For A Virtual Table
7155 ** CAPI3REF: Virtual Table Interface Configuration
7171 ** CAPI3REF: Virtual Table Configuration Options
7212 ** CAPI3REF: Determine The Virtual Table Conflict Policy
7899 typedef struct Table Table;
8027 #define BTREE_INTKEY 1 /* Table has only 64-bit signed integer keys */
8028 #define BTREE_BLOBKEY 2 /* Table has keys only - no data */
9340 Table *pSeqTab; /* The sqlite_sequence table used by AUTOINCREMENT */
9858 ** the Table.pVTable member variable of the corresponding Table object.
9864 ** When an in-memory Table object is deleted (for example when the
9867 ** immediately. Instead, they are moved from the Table.pVTable list to
9894 ** Table.zName is the name of the table. The case of the original
9898 ** Table.nCol is the number of columns in this table. Table.aCol is a
9901 ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
9902 ** the column that is that key. Otherwise Table.iPKey is negative. Note
9909 ** Table.tnum is the page number for the root BTree page of the table in the
9910 ** database file. If Table.iDb is the index of the database table backend
9914 ** when the VDBE cursor to the table is closed. In this case Table.tnum
9920 struct Table {
9929 u16 nRef; /* Number of pointers to this Table */
9947 Table *pNextZombie; /* Next on the Parse.pZombieTab list */
9955 #define TF_HasPrimaryKey 0x04 /* Table has a primary key */
9995 Table *pFrom; /* Table containing the REFERENCES clause (aka: Child) */
10107 ** In the Table structure describing Ex1, nCol==3 because there are
10127 Table *pTable; /* The SQL table being indexed */
10189 Table *pTab; /* Source table */
10327 Table *pTab; /* Table for TK_COLUMN expressions. */
10447 int idx; /* Index in some Table.aCol[] of a column named zName */
10493 Table *pTab; /* An SQL table corresponding to zName */
10602 #define WHERE_OMIT_OPEN 0x0010 /* Table cursors are already open */
10718 #define SF_HasTypeInfo 0x0020 /* FROM subqueries have Table metadata */
10756 ** tables, the following information is attached to the Table.u.autoInc.p
10765 Table *pTab; /* Table this info block refers to */
10853 int iTable; /* Table cursor number */
10854 int iColumn; /* Table column number */
10877 Table *pTriggerTab; /* Table triggers are being coded for */
10899 Table *pNewTable; /* A table being constructed by CREATE TABLE */
10906 Table **apVtabLock; /* Pointer to virtual tables needing locking */
10909 Table *pZombieTab; /* List of Table objects to delete after code gen */
10953 * struct Table.
11322 SQLITE_PRIVATE Table *sqlite3ResultSetOfSelect(Parse*,Select*);
11353 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse*,Table*);
11359 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3*, Table*);
11388 SQLITE_PRIVATE Table *sqlite3SrcListLookup(Parse*, SrcList*);
11389 SQLITE_PRIVATE int sqlite3IsReadOnly(Parse*, Table*, int);
11390 SQLITE_PRIVATE void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
11398 SQLITE_PRIVATE int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int);
11399 SQLITE_PRIVATE void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
11416 SQLITE_PRIVATE Table *sqlite3FindTable(sqlite3*,const char*, const char*);
11417 SQLITE_PRIVATE Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
11448 SQLITE_PRIVATE void sqlite3GenerateRowDelete(Parse*, Table*, int, int, int, Trigger *, int);
11449 SQLITE_PRIVATE void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int*);
11451 SQLITE_PRIVATE void sqlite3GenerateConstraintChecks(Parse*,Table*,int,int,
11453 SQLITE_PRIVATE void sqlite3CompleteInsertion(Parse*, Table*, int, int, int*, int, int, int);
11454 SQLITE_PRIVATE int sqlite3OpenTableAndIndices(Parse*, Table*, int, int);
11474 SQLITE_PRIVATE void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
11483 SQLITE_PRIVATE Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
11484 SQLITE_PRIVATE Trigger *sqlite3TriggerList(Parse *, Table *);
11485 SQLITE_PRIVATE void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
11487 SQLITE_PRIVATE void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
11488 void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
11497 SQLITE_PRIVATE u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
11578 SQLITE_PRIVATE void sqlite3TableAffinityStr(Vdbe *, Table *);
11643 SQLITE_PRIVATE void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
11718 SQLITE_PRIVATE void sqlite3VtabClear(sqlite3 *db, Table*);
11728 SQLITE_PRIVATE void sqlite3VtabMakeWritable(Parse*,Table*);
11734 SQLITE_PRIVATE int sqlite3VtabCallConnect(Parse*, Table*);
11745 SQLITE_PRIVATE VTable *sqlite3GetVTable(sqlite3*, Table*);
11758 SQLITE_PRIVATE void sqlite3FkCheck(Parse*, Table*, int, int);
11759 SQLITE_PRIVATE void sqlite3FkDropTable(Parse*, SrcList *, Table*);
11760 SQLITE_PRIVATE void sqlite3FkActions(Parse*, Table*, ExprList*, int);
11761 SQLITE_PRIVATE int sqlite3FkRequired(Parse*, Table*, int*, int);
11762 SQLITE_PRIVATE u32 sqlite3FkOldmask(Parse*, Table*);
11763 SQLITE_PRIVATE FKey *sqlite3FkReferences(Table *);
11772 SQLITE_PRIVATE void sqlite3FkDelete(sqlite3 *, Table*);
13166 sqlite3DeleteTable(db, (Table *)sqliteHashData(p));
63896 const char *zTbl; /* Table name - used by the opdate hook */
67543 const char *zTbl; /* Table name - used by the opdate hook */
69836 int iCol; /* Table column this handle is open on */
69962 Table *pTab;
71331 ** Table of methods for JournalFile sqlite3_file object.
71615 ** Table of methods for MemJournal sqlite3_file object.
71911 ** pExpr->pTab Points to the Table structure of X.Y (even if
71962 Table *pTab;
72032 Table *pTab = 0;
72926 ** Expr.pTab Points to the Table object for X.Y
72935 ** Table-name and function resolution occurs on the substituted expression
73918 Table *pTab;
74368 Table *pTab;
74468 Table *pTab = p->pSrc->a[0].pTab; /* Table <table>. */
75147 Table *pTab, /* The table containing the value */
75174 Table *pTab, /* Description of the table we are reading from */
75730 Table *pTab = pExpr->pTab;
77059 static char *whereForeignKeys(Parse *pParse, Table *pTab){
77075 static char *whereTempTriggers(Parse *pParse, Table *pTab){
77109 static void reloadTableSchema(Parse *pParse, Table *pTab, const char *zName){
77177 Table *pTab; /* Table being renamed */
77349 Table *pFrom = p->pFrom;
77397 ** The Table structure pParse->pNewTable was extended to include
77401 Table *pNew; /* Copy of pParse->pNewTable */
77402 Table *pTab; /* Table being altered */
77405 const char *zTab; /* Table name */
77514 ** This routine makes a (partial) copy of the Table structure
77518 ** the copy. The copy of the Table structure is deleted by tokenize.c
77525 Table *pNew;
77526 Table *pTab;
77559 /* Put a copy of the Table struct in Parse.pNewTable for the
77566 pNew = (Table*)sqlite3DbMallocZero(db, sizeof(Table));
77669 Table *pStat;
77711 Table *pTab, /* Table whose indices are to be analyzed */
78001 Table *pTab = (Table*)sqliteHashData(k);
78012 static void analyzeTable(Parse *pParse, Table *pTab, Index *pOnlyIdx){
78048 Table *pTab;
78124 Table *pTable;
78988 const char *zTab, /* Table name */
79026 Table *pTab = 0; /* The table being read */
79403 SQLITE_PRIVATE Table *sqlite3FindTable(sqlite3 *db, const char *zName, const char *zDatabase){
79404 Table *p = 0;
79431 SQLITE_PRIVATE Table *sqlite3LocateTable(
79437 Table *p;
79501 ** unlike that index from its Table then remove the index from
79615 ** Table.aCol[] array).
79617 static void sqliteDeleteColumnNames(sqlite3 *db, Table *pTable){
79635 ** Table. No changes are made to disk by this routine.
79642 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
79669 /* Delete the Table structure itself.
79689 Table *p;
79866 Table *pTable;
79962 pTable = sqlite3DbMallocZero(db, sizeof(Table));
80081 Table *p;
80130 Table *p;
80207 Table *p;
80229 Table *p;
80263 ** then we will try to use that column as the rowid. Set the Table.iPKey
80265 ** INTEGER PRIMARY KEY column. Table.iPKey is set to -1 if there is
80278 Table *pTab = pParse->pNewTable;
80341 Table *pTab = pParse->pNewTable;
80356 Table *p;
80507 static char *createTableStmt(sqlite3 *db, Table *p){
80597 Table *p;
80691 Table *pSelTab;
80766 Table *pOld;
80808 Table *p;
80873 ** The Table structure pTable is really a VIEW. Fill in the names of
80877 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
80878 Table *pSelTab; /* A fake table from which we get the result set */
80977 Table *pTab = sqliteHashData(i);
81017 Table *pTab = sqliteHashData(pElem);
81066 static void destroyTable(Parse *pParse, Table *pTab){
81147 Table *pTab;
81328 Table *p = pParse->pNewTable;
81440 Table *pTab;
81460 Table *pTab = pIndex->pTable; /* The table that is indexed */
81583 SrcList *pTblName, /* Table to index. Use pParse->pNewTable if 0 */
81592 Table *pTab = 0; /* Table to be indexed */
82121 Table *pTab = pIndex->pTable;
82356 Token *pTable, /* Table to append */
82797 static void reindexTable(Parse *pParse, Table *pTab, char const *zColl){
82821 Table *pTab; /* A table in the database */
82827 pTab = (Table*)sqliteHashData(k);
82852 Table *pTab; /* A table in the database */
83363 Table *pTab = sqliteHashData(pElem);
83425 ** pSrc->a[0].pTab Pointer to the Table object
83429 SQLITE_PRIVATE Table *sqlite3SrcListLookup(Parse *pParse, SrcList *pSrc){
83431 Table *pTab;
83450 SQLITE_PRIVATE int sqlite3IsReadOnly(Parse *pParse, Table *pTab, int viewOk){
83489 Table *pView, /* View definition */
83627 Table *pTab; /* The table from which records will be deleted */
83656 ** an SrcList* parameter instead of just a Table* parameter.
83881 Table *pTab, /* Table containing the row to be deleted */
83987 Table *pTab, /* Table containing the row to be deleted */
84022 Table *pTab = pIdx->pTable;
85843 Table *pParent, /* Parent table of FK constraint pFKey */
85977 Table *pTab, /* Parent table of FK pFKey */
86132 Table *pTab,
86253 SQLITE_PRIVATE FKey *sqlite3FkReferences(Table *pTab){
86294 SQLITE_PRIVATE void sqlite3FkDropTable(Parse *pParse, SrcList *pName, Table *pTab){
86357 Table *pTab, /* Row is being deleted from this table */
86379 Table *pTo; /* Parent table of foreign key pFKey */
86520 Table *pTab /* Table being modified */
86556 Table *pTab, /* Table being modified */
86631 Table *pTab, /* Table being updated or deleted from */
86816 Table *pTab, /* Table being updated or deleted from */
86842 SQLITE_PRIVATE void sqlite3FkDelete(sqlite3 *db, Table *pTab){
86904 Table *pTab, /* The table to be opened */
86948 Table *pTab = pIdx->pTable;
86979 SQLITE_PRIVATE void sqlite3TableAffinityStr(Vdbe *v, Table *pTab){
86982 ** stored as a member of the Table structure for subsequent use.
86985 ** sqlite3DeleteTable() when the Table structure itself is cleaned up.
87016 static int readsTable(Parse *p, int iStartAddr, int iDb, Table *pTab){
87074 Table *pTab /* The table we are writing to */
87205 Table *pDest, /* The table we are inserting into */
87322 Table *pTab; /* The table to insert into. aka TABLE */
88020 Table *pTab, /* the table into which we are inserting */
88037 int iCur; /* Table cursor number */
88306 Table *pTab, /* the table into which we are inserting */
88366 Table *pTab, /* Table to be opened */
88489 Table *pDest, /* The table we are inserting into */
88495 Table *pSrc; /* The table in the FROM clause of SELECT */
90825 Table *pTab;
90864 Table *pTab;
90888 Table *pTab;
90951 Table *pTab;
91079 Table *pTab = sqliteHashData(x);
91109 Table *pTab = sqliteHashData(x);
91625 Table *pTab;
92533 static int columnIndex(Table *pTab, const char *zCol){
92679 Table *pLeftTab = pLeft->pTab;
92680 Table *pRightTab = pRight->pTab;
92736 int iLeft; /* Table on the left with matching column name */
93367 Table *pTab = 0; /* Table structure column is extracted from */
93544 Table *pTab;
93619 Table *pTab; /* Table associated with this expression */
93715 ** Given a SELECT statement, generate a Table structure that describes
93718 SQLITE_PRIVATE Table *sqlite3ResultSetOfSelect(Parse *pParse, Select *pSelect){
93719 Table *pTab;
93730 pTab = sqlite3DbMallocZero(db, sizeof(Table) );
94864 int iTable, /* Table to be substituted */
94896 int iTable, /* Table to be substituted */
94908 int iTable, /* Table to be replaced */
95253 /* Defer deleting the Table object associated with the
95261 Table *pTabToDel = pSubitem->pTab;
95453 ** does match this pattern, then a pointer to the Table object representing
95456 static Table *isSimpleCount(Select *p, AggInfo *pAggInfo){
95457 Table *pTab;
95488 Table *pTab = pFrom->pTab;
95557 Table *pTab;
95571 pFrom->pTab = pTab = sqlite3DbMallocZero(db, sizeof(Table));
95667 Table *pTab = pFrom->pTab;
95790 ** information to the Table structure that represents the result set
95793 ** The Table structure that represents the result set was constructed
95810 Table *pTab = pFrom->pTab;
95827 ** the Table structures of all FROM-clause subqueries in a
95848 ** * Ephemeral Table objects are created for all FROM-clause subqueries.
96002 Table *pTab, /* Table being queried */
96091 int distinct; /* Table to use for the distinct set */
96675 Table *pTab;
96677 /* If isSimpleCount() returns a pointer to a Table structure, then
96682 ** where the Table structure returned represents table <tbl>.
97181 SQLITE_PRIVATE Trigger *sqlite3TriggerList(Parse *pParse, Table *pTab){
97227 Table *pTab; /* Table that the trigger fires off of */
97463 Table *pTab;
97664 ** Return a pointer to the Table structure for the table that a trigger
97667 static Table *tableOfTrigger(Trigger *pTrigger){
97677 Table *pTable;
97743 Table *pTab = tableOfTrigger(pTrigger);
97779 Table *pTab, /* The table the contains the triggers */
97951 Table *pTab, /* The table pTrigger is attached to */
98063 Table *pTab, /* The table trigger pTrigger is attached to */
98097 Table *pTab, /* The table to code triggers from */
98172 Table *pTab, /* The table to code triggers from */
98234 Table *pTab, /* The table to code triggers from */
98281 Table *pTab, /* The virtual table */
98320 SQLITE_PRIVATE void sqlite3ColumnDefault(Vdbe *v, Table *pTab, int i, int iReg){
98356 Table *pTab; /* The table to be updated */
98858 Table *pTab, /* The virtual table */
98869 int ephemTab; /* Table holding the result of the SELECT */
99302 Table *pTab;
99389 ** pTab is a pointer to a Table structure representing a virtual-table.
99393 SQLITE_PRIVATE VTable *sqlite3GetVTable(sqlite3 *db, Table *pTab){
99422 ** Table p is a virtual table. This function moves all elements in the
99428 static VTable *vtabDisconnectAll(sqlite3 *db, Table *p){
99499 ** Clear any and all virtual-table information from the Table record.
99500 ** This routine is called, for example, just before deleting the Table
99503 ** Since it is a virtual-table, the Table structure contains a pointer
99512 SQLITE_PRIVATE void sqlite3VtabClear(sqlite3 *db, Table *p){
99529 static void addModuleArgument(sqlite3 *db, Table *pTable, char *zArg){
99561 Table *pTable; /* The new virtual table */
99612 Table *pTab = pParse->pNewTable; /* The table being constructed */
99674 Table *pOld;
99721 Table *pTab,
99827 SQLITE_PRIVATE int sqlite3VtabCallConnect(Parse *pParse, Table *pTab){
99899 Table *pTab;
99942 Table *pTab;
100003 Table *pTab;
100213 Table *pTab;
100273 SQLITE_PRIVATE void sqlite3VtabMakeWritable(Parse *pParse, Table *pTab){
100276 Table **apVtabLock;
101206 WhereMaskSet *pMaskSet = pWC->pMaskSet; /* Table use masks */
101316 int iCursor = -1; /* Table cursor common to all terms */
101861 Table *pTab;
102226 struct SrcList_item *pSrc, /* Table we are trying to access */
102260 Table *pTable; /* Table tht might be indexed */
102334 Table *pTable; /* The table being indexed */
102587 static int vtabBestIndex(Parse *pParse, Table *pTab, sqlite3_index_info *p){
102646 Table *pTab = pSrc->pTab;
104001 static char *explainIndexRange(sqlite3 *db, WhereLevel *pLevel, Table *pTab){
104039 SrcList *pTabList, /* Table list this loop refers to */
105280 Table *pTab; /* Table to open */
105475 Table *pTab = pTabItem->pTab;
109746 ** will take responsibility for freeing the Table structure.
109761 Table *p = pParse->pZombieTab;
112673 const char *zTableName, /* Table name */
112683 Table *pTab = 0;
117564 Fts3Table *pTab, /* FTS Table pointer */
122891 Fts3Table *p, /* Table into which text will be inserted */
125050 Fts3Table *p, /* Table into which to insert */
125094 Fts3Table *p, /* Table being updated */