Lines Matching refs:TABLE
219 /* The code in this file defines a sqlite3 virtual-table module that
221 ** row in the schema table for each column in the database schema.
224 "CREATE TABLE x(" \
226 "tablename," /* Name of table */ \
236 "CREATE TABLE x(" \
238 "from_tbl," /* Name of table */ \
250 "CREATE TABLE x(" \
252 "tablename," /* Name of table */ \
259 "CREATE TABLE x(" \
261 "indexname," /* Name of table */ \
268 "CREATE TABLE x(" \
281 { "table_info", "table", "PRAGMA %Q.table_info(%Q)", SCHEMA },
282 { "foreign_key_list", "table", "PRAGMA %Q.foreign_key_list(%Q)", SCHEMA2 },
283 { "index_list", "table", "PRAGMA %Q.index_list(%Q)", SCHEMA3 },
292 /* A schema table object */
299 /* A schema table cursor object */
309 ** Table destructor for the schema module.
317 ** Table constructor for the schema module.
356 ** Open a new cursor on the schema table.
372 ** Close a schema table cursor.
463 ** sqlite_master (or sqlite_temp_master) table of the database
489 /* Set zSql to the SQL to the table_info pragma for the table currently
514 ** Reset a schema table cursor.
546 ** A virtual table module that merely echos method calls into TCL
748 zDel = sqlite3_mprintf("Error in table %s: %s", zTab, zMessage);
764 ** Create and populate temporary table "fkey".
770 "CREATE VIRTUAL TABLE temp.v_fkey USING schema(foreign_key_list);"
771 "CREATE VIRTUAL TABLE temp.v_col USING schema(table_info);"
772 "CREATE VIRTUAL TABLE temp.v_idxlist USING schema(index_list);"
773 "CREATE VIRTUAL TABLE temp.v_idxinfo USING schema(index_info);"
774 "CREATE VIRTUAL TABLE temp.v_triggers USING schema(trigger_list);"
775 "CREATE TABLE temp.fkey AS "
791 /* At this point the temp.fkey table is mostly populated. If any foreign
793 ** key of the parent table, the "to_col" values of the temp.fkey rows
812 /* Detect attempts to implicitly map to the primary key of a table
824 /* Fix all the implicit primary key mappings in the temp.fkey table. */
837 "CREATE TABLE temp.idx2 AS SELECT "
846 "CREATE TABLE temp.idx AS SELECT "
851 "CREATE TABLE temp.fkey2 AS SELECT "
856 "CREATE TABLE temp.triggers AS SELECT "
895 ** referencing table for which there is no corresponding row in
896 ** the referenced table.
906 ** referencing table causing it to correspond to no row in the
907 ** referenced table.
919 ** is to detect when a row is deleted from the referenced table to
920 ** which rows in the referencing table correspond. The action taken
930 ** is to detect when the key columns of a row in the referenced table
931 ** to which one or more rows in the referencing table correspond are
1022 /* Install the "schema" virtual table module */
1025 /* Create and populate a temp table with the information required to
1268 char *zDestTable; /* Name of destination table when MODE_Insert */
1290 #define MODE_Html 4 /* Generate an XHTML table */
1702 ** Set the destination table field of the callback_data structure to
1703 ** the name of the table given. Escape any quote characters in the
1704 ** table name.
1790 ** querying the SQLITE_MASTER table.
1949 ** Each row received by this callback consists of a table name,
1950 ** the table type ("index" or "table") and SQL to create the table.
1951 ** This routine should print text sufficient to recreate the table.
1973 }else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
1981 "VALUES('table','%q','%q',0,'%q');",
1990 if( strcmp(zType, "table")==0 ){
2134 ".dump ?TABLE? ... Dump the database in an SQL text format\n"
2135 " If TABLE specified, only dump tables matching\n"
2136 " LIKE pattern TABLE.\n"
2151 ".import FILE TABLE Import data from FILE into TABLE\n"
2152 ".indices ?TABLE? Show names of all indices\n"
2153 " If TABLE specified, only show indices for tables\n"
2154 " matching LIKE pattern TABLE.\n"
2162 ".mode MODE ?TABLE? Set output mode where MODE is one of:\n"
2165 " html HTML <table> code\n"
2166 " insert SQL insert statements for TABLE\n"
2178 ".schema ?TABLE? Show the CREATE statements\n"
2179 " If TABLE specified, only show tables matching\n"
2180 " LIKE pattern TABLE.\n"
2183 ".tables ?TABLE? List names of tables\n"
2184 " If TABLE specified, only list tables matching\n"
2185 " LIKE pattern TABLE.\n"
2386 "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'", 0
2402 "WHERE tbl_name LIKE shellstatic() AND type=='table'"
2493 char *zTable = azArg[2]; /* Insert data into this table */
2496 int nCol; /* Number of columns in the table */
2732 set_table_name(p, "table");
2859 new_argv[0] = "CREATE TABLE sqlite_master (\n"
2873 new_argv[0] = "CREATE TEMP TABLE sqlite_temp_master (\n"
2954 "WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' "
2957 "WHERE type IN ('table','view') "
2965 "WHERE type IN ('table','view') AND name LIKE shellstatic() "
2968 "WHERE type IN ('table','view') AND name LIKE shellstatic() "
