Lines Matching defs:Table
930 #define SQLITE_NOTFOUND 12 /* NOT USED. Table or record not found */
2674 #define SQLITE_CREATE_INDEX 1 /* Index Name Table Name */
2675 #define SQLITE_CREATE_TABLE 2 /* Table Name NULL */
2676 #define SQLITE_CREATE_TEMP_INDEX 3 /* Index Name Table Name */
2677 #define SQLITE_CREATE_TEMP_TABLE 4 /* Table Name NULL */
2678 #define SQLITE_CREATE_TEMP_TRIGGER 5 /* Trigger Name Table Name */
2680 #define SQLITE_CREATE_TRIGGER 7 /* Trigger Name Table Name */
2682 #define SQLITE_DELETE 9 /* Table Name NULL */
2683 #define SQLITE_DROP_INDEX 10 /* Index Name Table Name */
2684 #define SQLITE_DROP_TABLE 11 /* Table Name NULL */
2685 #define SQLITE_DROP_TEMP_INDEX 12 /* Index Name Table Name */
2686 #define SQLITE_DROP_TEMP_TABLE 13 /* Table Name NULL */
2687 #define SQLITE_DROP_TEMP_TRIGGER 14 /* Trigger Name Table Name */
2689 #define SQLITE_DROP_TRIGGER 16 /* Trigger Name Table Name */
2691 #define SQLITE_INSERT 18 /* Table Name NULL */
2693 #define SQLITE_READ 20 /* Table Name Column Name */
2696 #define SQLITE_UPDATE 23 /* Table Name Column Name */
2699 #define SQLITE_ALTER_TABLE 26 /* Database Name Table Name */
2701 #define SQLITE_ANALYZE 28 /* Table Name NULL */
2702 #define SQLITE_CREATE_VTABLE 29 /* Table Name Module Name */
2703 #define SQLITE_DROP_VTABLE 30 /* Table Name Module Name */
4661 ** CAPI3REF: Extract Metadata About A Column Of A Table
4725 const char *zTableName, /* Table name */
4831 ** CAPI3REF: Virtual Table Object
4877 ** CAPI3REF: Virtual Table Indexing Information
4937 } *aConstraint; /* Table of WHERE clause constraints */
4956 ** CAPI3REF: Virtual Table Constraint Operator Codes
4971 ** CAPI3REF: Register A Virtual Table Implementation
5008 ** CAPI3REF: Virtual Table Instance Object
5033 ** CAPI3REF: Virtual Table Cursor Object
5055 ** CAPI3REF: Declare The Schema Of A Virtual Table
5065 ** CAPI3REF: Overload A Function For A Virtual Table
7088 typedef struct Table Table;
7220 #define BTREE_INTKEY 1 /* Table has only 64-bit signed integer keys */
7221 #define BTREE_ZERODATA 2 /* Table has keys only - no data */
8512 Table *pSeqTab; /* The sqlite_sequence table used by AUTOINCREMENT */
8689 Table *pVTab; /* vtab with active Connect/Create method */
9001 ** the Table.pVTable member variable of the corresponding Table object.
9007 ** When an in-memory Table object is deleted (for example when the
9010 ** immediately. Instead, they are moved from the Table.pVTable list to
9035 ** Table.zName is the name of the table. The case of the original
9039 ** Table.nCol is the number of columns in this table. Table.aCol is a
9042 ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
9043 ** the column that is that key. Otherwise Table.iPKey is negative. Note
9050 ** Table.tnum is the page number for the root BTree page of the table in the
9051 ** database file. If Table.iDb is the index of the database table backend
9055 ** when the VDBE cursor to the table is closed. In this case Table.tnum
9061 struct Table {
9069 u16 nRef; /* Number of pointers to this Table */
9087 Table *pNextZombie; /* Next on the Parse.pZombieTab list */
9095 #define TF_HasPrimaryKey 0x04 /* Table has a primary key */
9135 Table *pFrom; /* Table containing the REFERENCES clause (aka: Child) */
9247 ** In the Table structure describing Ex1, nCol==3 because there are
9267 Table *pTable; /* The SQL table being indexed */
9327 Table *pTab; /* Source table */
9465 Table *pTab; /* Table for TK_COLUMN expressions. */
9585 int idx; /* Index in some Table.aCol[] of a column named zName */
9631 Table *pTab; /* An SQL table corresponding to zName */
9734 #define WHERE_OMIT_OPEN 0x0010 /* Table cursors are already open */
9844 #define SF_HasTypeInfo 0x0020 /* FROM subqueries have Table metadata */
9881 ** tables, the following information is attached to the Table.u.autoInc.p
9890 Table *pTab; /* Table this info block refers to */
9969 int iTable; /* Table cursor number */
9970 int iColumn; /* Table column number */
9993 Table *pTriggerTab; /* Table triggers are being coded for */
10016 Table *pNewTable; /* A table being constructed by CREATE TABLE */
10023 Table **apVtabLock; /* Pointer to virtual tables needing locking */
10026 Table *pZombieTab; /* List of Table objects to delete after code gen */
10065 * struct Table.
10433 SQLITE_PRIVATE Table *sqlite3ResultSetOfSelect(Parse*,Select*);
10462 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse*,Table*);
10468 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3*, Table*);
10497 SQLITE_PRIVATE Table *sqlite3SrcListLookup(Parse*, SrcList*);
10498 SQLITE_PRIVATE int sqlite3IsReadOnly(Parse*, Table*, int);
10499 SQLITE_PRIVATE void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
10507 SQLITE_PRIVATE int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int);
10508 SQLITE_PRIVATE void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
10526 SQLITE_PRIVATE Table *sqlite3FindTable(sqlite3*,const char*, const char*);
10527 SQLITE_PRIVATE Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
10557 SQLITE_PRIVATE void sqlite3GenerateRowDelete(Parse*, Table*, int, int, int, Trigger *, int);
10558 SQLITE_PRIVATE void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int*);
10560 SQLITE_PRIVATE void sqlite3GenerateConstraintChecks(Parse*,Table*,int,int,
10562 SQLITE_PRIVATE void sqlite3CompleteInsertion(Parse*, Table*, int, int, int*, int, int, int);
10563 SQLITE_PRIVATE int sqlite3OpenTableAndIndices(Parse*, Table*, int, int);
10583 SQLITE_PRIVATE void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
10592 SQLITE_PRIVATE Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
10593 SQLITE_PRIVATE Trigger *sqlite3TriggerList(Parse *, Table *);
10594 SQLITE_PRIVATE void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
10596 SQLITE_PRIVATE void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
10597 void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
10606 SQLITE_PRIVATE u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
10689 SQLITE_PRIVATE void sqlite3TableAffinityStr(Vdbe *, Table *);
10743 SQLITE_PRIVATE void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
10815 SQLITE_PRIVATE void sqlite3VtabClear(sqlite3 *db, Table*);
10824 SQLITE_PRIVATE void sqlite3VtabMakeWritable(Parse*,Table*);
10830 SQLITE_PRIVATE int sqlite3VtabCallConnect(Parse*, Table*);
10841 SQLITE_PRIVATE VTable *sqlite3GetVTable(sqlite3*, Table*);
10854 SQLITE_PRIVATE void sqlite3FkCheck(Parse*, Table*, int, int);
10855 SQLITE_PRIVATE void sqlite3FkDropTable(Parse*, SrcList *, Table*);
10856 SQLITE_PRIVATE void sqlite3FkActions(Parse*, Table*, ExprList*, int);
10857 SQLITE_PRIVATE int sqlite3FkRequired(Parse*, Table*, int*, int);
10858 SQLITE_PRIVATE u32 sqlite3FkOldmask(Parse*, Table*);
10859 SQLITE_PRIVATE FKey *sqlite3FkReferences(Table *);
10868 SQLITE_PRIVATE void sqlite3FkDelete(sqlite3 *, Table*);
12200 sqlite3DeleteTable(db, (Table *)sqliteHashData(p));
59856 const char *zTbl; /* Table name - used by the opdate hook */
63333 const char *zTbl; /* Table name - used by the opdate hook */
65548 Table *pTab;
66021 ** Table of methods for JournalFile sqlite3_file object.
66305 ** Table of methods for MemJournal sqlite3_file object.
66598 ** pExpr->pTab Points to the Table structure of X.Y (even if
66649 Table *pTab;
66719 Table *pTab = 0;
67599 ** Expr.pTab Points to the Table object for X.Y
67608 ** Table-name and function resolution occurs on the substituted expression
68585 Table *pTab;
69039 Table *pTab;
69139 Table *pTab = p->pSrc->a[0].pTab; /* Table <table>. */
69809 Table *pTab, /* The table containing the value */
69836 Table *pTab, /* Description of the table we are reading from */
70457 Table *pTab = pExpr->pTab;
71765 static char *whereForeignKeys(Parse *pParse, Table *pTab){
71781 static char *whereTempTriggers(Parse *pParse, Table *pTab){
71810 static void reloadTableSchema(Parse *pParse, Table *pTab, const char *zName){
71862 Table *pTab; /* Table being renamed */
72037 Table *pFrom = p->pFrom;
72085 ** The Table structure pParse->pNewTable was extended to include
72089 Table *pNew; /* Copy of pParse->pNewTable */
72090 Table *pTab; /* Table being altered */
72093 const char *zTab; /* Table name */
72202 ** This routine makes a (partial) copy of the Table structure
72206 ** the copy. The copy of the Table structure is deleted by tokenize.c
72213 Table *pNew;
72214 Table *pTab;
72244 /* Put a copy of the Table struct in Parse.pNewTable for the
72251 pNew = (Table*)sqlite3DbMallocZero(db, sizeof(Table));
72353 Table *pStat;
72395 Table *pTab, /* Table whose indices are to be analyzed */
72641 Table *pTab = (Table*)sqliteHashData(k);
72651 static void analyzeTable(Parse *pParse, Table *pTab){
72683 Table *pTab;
73581 const char *zTab, /* Table name */
73619 Table *pTab = 0; /* The table being read */
73995 SQLITE_PRIVATE Table *sqlite3FindTable(sqlite3 *db, const char *zName, const char *zDatabase){
73996 Table *p = 0;
74020 SQLITE_PRIVATE Table *sqlite3LocateTable(
74026 Table *p;
74087 ** unlike that index from its Table then remove the index from
74183 ** Table.aCol[] array).
74185 static void sqliteDeleteColumnNames(sqlite3 *db, Table *pTable){
74203 ** Table. No changes are made to disk by this routine.
74210 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
74236 /* Delete the Table structure itself.
74256 Table *p;
74432 Table *pTable;
74523 pTable = sqlite3DbMallocZero(db, sizeof(Table));
74640 Table *p;
74689 Table *p;
74766 Table *p;
74788 Table *p;
74822 ** then we will try to use that column as the rowid. Set the Table.iPKey
74824 ** INTEGER PRIMARY KEY column. Table.iPKey is set to -1 if there is
74837 Table *pTab = pParse->pNewTable;
74900 Table *pTab = pParse->pNewTable;
74915 Table *p;
75065 static char *createTableStmt(sqlite3 *db, Table *p){
75155 Table *p;
75249 Table *pSelTab;
75323 Table *pOld;
75364 Table *p;
75431 ** The Table structure pTable is really a VIEW. Fill in the names of
75435 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
75436 Table *pSelTab; /* A fake table from which we get the result set */
75533 Table *pTab = sqliteHashData(i);
75570 Table *pTab = sqliteHashData(pElem);
75619 static void destroyTable(Parse *pParse, Table *pTab){
75677 Table *pTab;
75864 Table *p = pParse->pNewTable;
75975 Table *pTab;
75995 Table *pTab = pIndex->pTable; /* The table that is indexed */
76082 SrcList *pTblName, /* Table to index. Use pParse->pNewTable if 0 */
76091 Table *pTab = 0; /* Table to be indexed */
76613 Table *pTab = pIndex->pTable;
76854 Token *pTable, /* Table to append */
77278 static void reindexTable(Parse *pParse, Table *pTab, char const *zColl){
77302 Table *pTab; /* A table in the database */
77307 pTab = (Table*)sqliteHashData(k);
77332 Table *pTab; /* A table in the database */
77843 Table *pTab = sqliteHashData(pElem);
77897 SQLITE_PRIVATE Table *sqlite3SrcListLookup(Parse *pParse, SrcList *pSrc){
77899 Table *pTab;
77918 SQLITE_PRIVATE int sqlite3IsReadOnly(Parse *pParse, Table *pTab, int viewOk){
77957 Table *pView, /* View definition */
78095 Table *pTab; /* The table from which records will be deleted */
78124 ** an SrcList* parameter instead of just a Table* parameter.
78346 Table *pTab, /* Table containing the row to be deleted */
78452 Table *pTab, /* Table containing the row to be deleted */
78487 Table *pTab = pIdx->pTable;
80289 Table *pParent, /* Parent table of FK constraint pFKey */
80423 Table *pTab, /* Parent table of FK pFKey */
80566 Table *pTab,
80687 SQLITE_PRIVATE FKey *sqlite3FkReferences(Table *pTab){
80728 SQLITE_PRIVATE void sqlite3FkDropTable(Parse *pParse, SrcList *pName, Table *pTab){
80791 Table *pTab, /* Row is being deleted from this table */
80815 Table *pTo; /* Parent table of foreign key pFKey */
80939 Table *pTab /* Table being modified */
80975 Table *pTab, /* Table being modified */
81050 Table *pTab, /* Table being updated or deleted from */
81235 Table *pTab, /* Table being updated or deleted from */
81261 SQLITE_PRIVATE void sqlite3FkDelete(sqlite3 *db, Table *pTab){
81322 Table *pTab, /* The table to be opened */
81366 Table *pTab = pIdx->pTable;
81397 SQLITE_PRIVATE void sqlite3TableAffinityStr(Vdbe *v, Table *pTab){
81400 ** stored as a member of the Table structure for subsequent use.
81403 ** sqlite3DeleteTable() when the Table structure itself is cleaned up.
81434 static int readsTable(Parse *p, int iStartAddr, int iDb, Table *pTab){
81492 Table *pTab /* The table we are writing to */
81621 Table *pDest, /* The table we are inserting into */
81738 Table *pTab; /* The table to insert into. aka TABLE */
82437 Table *pTab, /* the table into which we are inserting */
82454 int iCur; /* Table cursor number */
82723 Table *pTab, /* the table into which we are inserting */
82783 Table *pTab, /* Table to be opened */
82906 Table *pDest, /* The table we are inserting into */
82912 Table *pSrc; /* The table in the FROM clause of SELECT */
85135 Table *pTab;
85174 Table *pTab;
85198 Table *pTab;
85261 Table *pTab;
85388 Table *pTab = sqliteHashData(x);
85418 Table *pTab = sqliteHashData(x);
85918 Table *pTab;
86826 static int columnIndex(Table *pTab, const char *zCol){
86972 Table *pLeftTab = pLeft->pTab;
86973 Table *pRightTab = pRight->pTab;
87029 int iLeft; /* Table on the left with matching column name */
87559 Table *pTab = 0; /* Table structure column is extracted from */
87736 Table *pTab;
87827 Table *pTab; /* Table associated with this expression */
87923 ** Given a SELECT statement, generate a Table structure that describes
87926 SQLITE_PRIVATE Table *sqlite3ResultSetOfSelect(Parse *pParse, Select *pSelect){
87927 Table *pTab;
87938 pTab = sqlite3DbMallocZero(db, sizeof(Table) );
89038 int iTable, /* Table to be substituted */
89070 int iTable, /* Table to be substituted */
89082 int iTable, /* Table to be replaced */
89421 /* Defer deleting the Table object associated with the
89429 Table *pTabToDel = pSubitem->pTab;
89621 ** does match this pattern, then a pointer to the Table object representing
89624 static Table *isSimpleCount(Select *p, AggInfo *pAggInfo){
89625 Table *pTab;
89656 Table *pTab = pFrom->pTab;
89725 Table *pTab;
89739 pFrom->pTab = pTab = sqlite3DbMallocZero(db, sizeof(Table));
89834 Table *pTab = pFrom->pTab;
89957 ** information to the Table structure that represents the result set
89960 ** The Table structure that represents the result set was constructed
89977 Table *pTab = pFrom->pTab;
89994 ** the Table structures of all FROM-clause subqueries in a
90015 ** * Ephemeral Table objects are created for all FROM-clause subqueries.
90232 int distinct; /* Table to use for the distinct set */
90703 Table *pTab;
90705 /* If isSimpleCount() returns a pointer to a Table structure, then
90710 ** where the Table structure returned represents table <tbl>.
91198 SQLITE_PRIVATE Trigger *sqlite3TriggerList(Parse *pParse, Table *pTab){
91243 Table *pTab; /* Table that the trigger fires off of */
91463 Table *pTab;
91660 ** Return a pointer to the Table structure for the table that a trigger
91663 static Table *tableOfTrigger(Trigger *pTrigger){
91673 Table *pTable;
91736 Table *pTab = tableOfTrigger(pTrigger);
91772 Table *pTab, /* The table the contains the triggers */
91940 Table *pTab, /* The table pTrigger is attached to */
92052 Table *pTab, /* The table trigger pTrigger is attached to */
92086 Table *pTab, /* The table to code triggers from */
92161 Table *pTab, /* The table to code triggers from */
92223 Table *pTab, /* The table to code triggers from */
92270 Table *pTab, /* The virtual table */
92308 SQLITE_PRIVATE void sqlite3ColumnDefault(Vdbe *v, Table *pTab, int i, int iReg){
92344 Table *pTab; /* The table to be updated */
92846 Table *pTab, /* The virtual table */
92856 int ephemTab; /* Table holding the result of the SELECT */
93355 ** pTab is a pointer to a Table structure representing a virtual-table.
93359 SQLITE_PRIVATE VTable *sqlite3GetVTable(sqlite3 *db, Table *pTab){
93388 ** Table p is a virtual table. This function moves all elements in the
93394 static VTable *vtabDisconnectAll(sqlite3 *db, Table *p){
93466 ** Clear any and all virtual-table information from the Table record.
93467 ** This routine is called, for example, just before deleting the Table
93470 ** Since it is a virtual-table, the Table structure contains a pointer
93479 SQLITE_PRIVATE void sqlite3VtabClear(sqlite3 *db, Table *p){
93496 static void addModuleArgument(sqlite3 *db, Table *pTable, char *zArg){
93528 Table *pTable; /* The new virtual table */
93579 Table *pTab = pParse->pNewTable; /* The table being constructed */
93641 Table *pOld;
93687 Table *pTab,
93791 SQLITE_PRIVATE int sqlite3VtabCallConnect(Parse *pParse, Table *pTab){
93856 Table *pTab;
93896 Table *pTab;
93958 Table *pTab;
94116 Table *pTab;
94176 SQLITE_PRIVATE void sqlite3VtabMakeWritable(Parse *pParse, Table *pTab){
94179 Table **apVtabLock;
95041 WhereMaskSet *pMaskSet = pWC->pMaskSet; /* Table use masks */
95151 int iCursor = -1; /* Table cursor common to all terms */
95854 struct SrcList_item *pSrc, /* Table we are trying to access */
95888 Table *pTable; /* Table tht might be indexed */
95954 Table *pTable; /* The table being indexed */
96206 static int vtabBestIndex(Parse *pParse, Table *pTab, sqlite3_index_info *p){
96264 Table *pTab = pSrc->pTab;
98452 Table *pTab; /* Table to open */
98675 Table *pTab = pTabItem->pTab;
102945 ** will take responsibility for freeing the Table structure.
102959 Table *p = pParse->pZombieTab;
105473 const char *zTableName, /* Table name */
105483 Table *pTab = 0;
114555 Fts3Table *p, /* Table into which to insert */
114589 Fts3Table *p, /* Table being updated */
114812 Fts3Table *pTab; /* FTS3 Table */