Lines Matching refs:TABLE
426 char *zDestTable; /* Name of destination table when MODE_Insert */
449 #define MODE_Html 4 /* Generate an XHTML table */
856 ** Set the destination table field of the callback_data structure to
857 ** the name of the table given. Escape any quote characters in the
858 ** table name.
1243 ** Each row received by this callback consists of a table name,
1244 ** the table type ("index" or "table") and SQL to create the table.
1245 ** This routine should print text sufficient to recreate the table.
1267 }else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
1275 "VALUES('table','%q','%q',0,'%q');",
1284 if( strcmp(zType, "table")==0 ){
1389 ".dump ?TABLE? ... Dump the database in an SQL text format\n"
1390 " If TABLE specified, only dump tables matching\n"
1391 " LIKE pattern TABLE.\n"
1398 ".import FILE TABLE Import data from FILE into TABLE\n"
1399 ".indices ?TABLE? Show names of all indices\n"
1400 " If TABLE specified, only show indices for tables\n"
1401 " matching LIKE pattern TABLE.\n"
1409 ".mode MODE ?TABLE? Set output mode where MODE is one of:\n"
1412 " html HTML <table> code\n"
1413 " insert SQL insert statements for TABLE\n"
1425 ".schema ?TABLE? Show the CREATE statements\n"
1426 " If TABLE specified, only show tables matching\n"
1427 " LIKE pattern TABLE.\n"
1431 ".tables ?TABLE? List names of tables\n"
1432 " If TABLE specified, only list tables matching\n"
1433 " LIKE pattern TABLE.\n"
1635 "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'"
1651 "WHERE tbl_name LIKE shellstatic() AND type=='table'"
1727 char *zTable = azArg[2]; /* Insert data into this table */
1730 int nCol; /* Number of columns in the table */
1976 set_table_name(p, "table");
2103 new_argv[0] = "CREATE TABLE sqlite_master (\n"
2117 new_argv[0] = "CREATE TEMP TABLE sqlite_temp_master (\n"
2204 "WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' "
2207 "WHERE type IN ('table','view') "
2215 "WHERE type IN ('table','view') AND name LIKE shellstatic() "
2218 "WHERE type IN ('table','view') AND name LIKE shellstatic() "
