Lines Matching refs:TABLE
431 char *zDestTable; /* Name of destination table when MODE_Insert */
454 #define MODE_Html 4 /* Generate an XHTML table */
861 ** Set the destination table field of the callback_data structure to
862 ** the name of the table given. Escape any quote characters in the
863 ** table name.
1248 ** Each row received by this callback consists of a table name,
1249 ** the table type ("index" or "table") and SQL to create the table.
1250 ** This routine should print text sufficient to recreate the table.
1272 }else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
1280 "VALUES('table','%q','%q',0,'%q');",
1289 if( strcmp(zType, "table")==0 ){
1394 ".dump ?TABLE? ... Dump the database in an SQL text format\n"
1395 " If TABLE specified, only dump tables matching\n"
1396 " LIKE pattern TABLE.\n"
1403 ".import FILE TABLE Import data from FILE into TABLE\n"
1404 ".indices ?TABLE? Show names of all indices\n"
1405 " If TABLE specified, only show indices for tables\n"
1406 " matching LIKE pattern TABLE.\n"
1414 ".mode MODE ?TABLE? Set output mode where MODE is one of:\n"
1417 " html HTML <table> code\n"
1418 " insert SQL insert statements for TABLE\n"
1430 ".schema ?TABLE? Show the CREATE statements\n"
1431 " If TABLE specified, only show tables matching\n"
1432 " LIKE pattern TABLE.\n"
1436 ".tables ?TABLE? List names of tables\n"
1437 " If TABLE specified, only list tables matching\n"
1438 " LIKE pattern TABLE.\n"
1654 "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'"
1670 "WHERE tbl_name LIKE shellstatic() AND type=='table'"
1746 char *zTable = azArg[2]; /* Insert data into this table */
1749 int nCol; /* Number of columns in the table */
1995 set_table_name(p, "table");
2122 new_argv[0] = "CREATE TABLE sqlite_master (\n"
2136 new_argv[0] = "CREATE TEMP TABLE sqlite_temp_master (\n"
2223 "WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' "
2226 "WHERE type IN ('table','view') "
2234 "WHERE type IN ('table','view') AND name LIKE shellstatic() "
2237 "WHERE type IN ('table','view') AND name LIKE shellstatic() "