Lines Matching refs:name
479 ** This is the name of our program. It is set in main(), used
905 ** Construct a fake object name and column list to describe the structure
911 const char *zName /* The name of the virtual table */
978 ** Add the schema name X to the CREATE statement in S and return the result.
991 ** This UDF is used by the .schema command to insert the schema name of
1205 extern const char *windirent_getenv(const char *name);
1244 const char *name
1251 dwRet = GetEnvironmentVariableA(name, value, dwSize);
1275 SIZE_T namesize = sizeof(data.name) / sizeof(data.name[0]);
1286 _snprintf(data.name, namesize, "%s\\*", dirname);
1287 dirp->d_handle = _findfirst(data.name, &data);
1309 strncpy(dirp->d_first.d_name, data.name, NAME_MAX);
1342 strncpy(dirp->d_next.d_name, data.name, NAME_MAX);
1386 strncpy(entry->d_name, data.name, NAME_MAX);
3066 ** WITH c(name,bin) AS (VALUES
3071 ** SELECT c.name, decimal_mul(ieee754_mantissa(c.bin),pow2.v)
3811 ** this file to prevent name collisions with C-library functions of the
3812 ** same name.
4693 ** name: Path to file or directory (text value).
4702 ** And the paths returned in the "name" column of the table are also
4747 #define FSDIR_SCHEMA "(name,mode,mtime,data,path HIDDEN,dir HIDDEN)"
4943 ** Argument zFile is the name of a file that will be created and/or written
5689 ** times, for example if the same column name is used to two or more
5891 "SELECT name FROM \"%w\".sqlite_schema",
5915 "SELECT pti.name FROM \"%w\".sqlite_schema AS sm"
5916 " JOIN pragma_table_info(sm.name,%Q) AS pti"
6861 ** SELECT name, sz, datetime(mtime,'unixepoch') FROM zipfile($filename);
6939 "name PRIMARY KEY," /* 0: Name of file in zip archive */
7038 *** file name length 2 bytes
7079 *** file name length 2 bytes
7181 ** argv[0] -> module name ("zipfile")
7182 ** argv[1] -> database name
7183 ** argv[2] -> table name
7184 ** argv[...] -> "column name" and other module argument fields.
7199 /* If the table name is not "zipfile", require that the argument be
7885 case 0: /* name */
7939 ** the final character in the name is '/'. */
8215 /* Add the file name */
8406 int bUpdate = 0; /* True for an update that modifies "name" */
8522 zipfileTableErr(pTab, "duplicate name: \"%s\"", zPath);
8708 "\"file-name-length\" : %u, "
8785 ** SELECT zipfile(name,data) ...
8786 ** SELECT zipfile(name,mode,mtime,data) ...
8787 ** SELECT zipfile(name,mode,mtime,data,method) ...
8812 char *zName = 0; /* Path (name) of new entry */
8839 /* Check that the 'name' parameter looks ok. */
8897 zErr = sqlite3_mprintf("non-directory name must not end with /");
9407 ** A temp table name that we assume no user database will actually use.
9409 ** conflicting name will be ignored.
9455 char *zName; /* Table name */
9764 ** argv[0] -> module name
9765 ** argv[1] -> database name
9766 ** argv[2] -> table name
10051 const char *zTab, /* Table name */
10343 /* Hash the list of columns to come up with a name for the index */
10346 char *zName = 0; /* Index name */
10358 zFmt = "SELECT count(*) FROM sqlite_schema WHERE name=%Q"
10372 /* This return means "Gave up trying to find a unique index name." */
10762 "SELECT type, name, sql, 1 FROM sqlite_schema "
10763 "WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%%' "
10765 "SELECT type, name, sql, 2 FROM sqlite_schema "
10767 " AND tbl_name IN(SELECT name FROM sqlite_schema WHERE type = 'view') "
10942 " pragma_index_list(s.name) AS l, "
10943 " pragma_index_info(l.name) AS i "
11093 "SELECT s.rowid, s.name, l.name FROM "
11095 " pragma_index_list(s.name) AS l "
11098 "SELECT name, coll FROM pragma_index_xinfo(?) WHERE key";
11210 "SELECT sql FROM sqlite_schema WHERE name NOT LIKE 'sqlite_%%'"
11323 *pzErr = sqlite3_mprintf("Cannot find a unique index name to propose.");
12127 ** "main", "temp" or the name of an attached database) and set
12446 ** database handle and the second the name of a database attached to that
12447 ** handle (i.e. "main", "temp" or the name of an attached database).
12501 ** The pArg argument points to a string buffer containing the name
13627 "CREATE TABLE recovery.schema(type, name, tbl_name, rootpage, sql);"
13637 ** Otherwise, argument zName must be the name of a table that has just been
13760 "WITH dbschema(rootpage, name, sql, tbl, isVirtual, isIndex) AS ("
13761 " SELECT rootpage, name, sql, "
13767 "SELECT rootpage, tbl, isVirtual, name, sql"
13770 " ORDER BY tbl DESC, name=='sqlite_sequence' DESC"
13774 "SELECT name FROM sqlite_schema "
13870 ** CREATE TABLE name(a, b GENERATED ALWAYS AS (a+1) STORED, c, d, e);
13976 ** the name of the new table. It is the responsibility of the caller to
13991 "SELECT 1 FROM sqlite_schema WHERE name=?"
14045 ** table in the output database. The name of the table is zTab, and it has
15379 ** name of the auxiliary database that is ATTACH-ed to the database
15484 char *zName; /* Symbolic name for this session */
15601 const char * zDefaultDbName; /* Default name for db file */
16981 " 'SELECT hex(sha3_query(''SELECT type,name,tbl_name,sql "
16983 " hex(sha3_query('SELECT type,name,tbl_name,sql "
16988 " printf('%w',name) || '\" NOT INDEXED'',224))',\n"
16989 " hex(sha3_query(printf('SELECT * FROM \"%w\" NOT INDEXED',name),224))\n"
16991 " SELECT name FROM sqlite_schema\n"
16993 " AND name<>'selftest'\n"
16996 " ORDER BY name;\n"
17013 ** the name of the table given. Escape any quote characters in the
17014 ** table name.
17254 sqlite3_snprintf(30, z+x, "database name:");
17256 sqlite3_snprintf(30, z+x, "table name:");
17258 sqlite3_snprintf(30, z+x, "origin name:");
17589 ** No bindings occur if this table does not exist. The name of the table
18077 /* allocate space for col name ptr, value ptr, and type */
18446 ** name of the rowid column.
18520 /* Only preserve the rowid if we can find a name to use for the
18529 /* At this point, we know that azRowid[j] is not the name of any
18531 ** name for the rowid before adding it to azCol[0]. WITHOUT ROWID
18561 ** Each row received by this callback consists of a table name,
18599 "INSERT INTO sqlite_schema(type,name,tbl_name,rootpage,sql)"
18624 /* Always quote the table name, even if it appears to be pure ascii,
18628 /* If preserving the rowid, add a column list after the table name.
18865 " TABLE The name of SQL table used for \"insert\" mode",
18924 " --lost-and-found TABLE Alternative name for the lost-and-found table",
19007 ".vfsname ?AUX? Print the name of the VFS stack",
19176 ** If the file does not exist or is empty but its name looks like a ZIP
19464 ** ZIP archive if the file does not exist or is empty and its name matches
19468 #define OPEN_DB_ZIPFILE 0x002 /* Open as ZIP if name matches *.zip */
20167 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_schema"
20196 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_schema"
20557 ** memory used to hold the name of the temp file.
20568 ** Create a new temp file name with the given suffix.
20603 ** called with four arguments - the parent table name, the parent column name,
20604 ** the child table name and the child column name.
20701 ** 5. The name of the parent table.
20707 " 'EXPLAIN QUERY PLAN SELECT 1 FROM ' || quote(s.name) || ' WHERE '"
20708 " || group_concat(quote(s.name) || '.' || quote(f.[from]) || '=?' "
20710 " f.[table], COALESCE(f.[to], p.[name]), s.name, f.[from]),' AND ')"
20712 " 'SEARCH ' || s.name || ' USING COVERING INDEX*('"
20715 " s.name || '(' || group_concat(f.[from], ', ') || ')'"
20717 " f.[table] || '(' || group_concat(COALESCE(f.[to], p.[name])) || ')'"
20719 " 'CREATE INDEX ' || quote(s.name ||'_'|| group_concat(f.[from], '_'))"
20720 " || ' ON ' || quote(s.name) || '('"
20723 " f.[table], COALESCE(f.[to], p.[name]), s.name, f.[from]), ', ')"
20727 "FROM sqlite_schema AS s, pragma_foreign_key_list(s.name) AS f "
20729 "GROUP BY s.name, f.id "
20730 "ORDER BY (CASE WHEN ? THEN f.[table] ELSE s.name END)"
21204 ** exact equality when pAr->bGlob is false or a "name GLOB pattern" match
21217 ? "SELECT name FROM %s WHERE glob($name,name)"
21218 : "SELECT name FROM %s WHERE name=$name";
21221 j = sqlite3_bind_parameter_index(pTest, "$name");
21267 "%z%s name %s '%q' OR substr(name,1,%d) %s '%q/'",
21287 "name",
21288 "lsmode(mode), sz, datetime(mtime, 'unixepoch'), name"
21369 " ($dir || name),"
21370 " writefile(($dir || name), %s, mode, mtime) "
21372 " AND name NOT GLOB '*..[/\\]*'";
21480 " name TEXT PRIMARY KEY, -- name of the file\n"
21488 "REPLACE INTO %s(name,mode,mtime,sz,data)\n"
21501 "REPLACE INTO %s(name,mode,mtime,data)\n"
21550 " WHERE mem.name=disk.name"
21559 pAr->bVerbose ? "shell_putsnl(name)" : "name",
21641 && sqlite3_table_column_metadata(cmd.db,0,"sqlar","name",0,0,0,0,0)
21728 /* This option determines the name of the ATTACH-ed database used
21818 name TEXT, nlen INT, chop INT, reps INT, suff TEXT);\
21820 SELECT DISTINCT t.name FROM ColNames t \
21821 WHERE t.name COLLATE NOCASE IN (\
21822 SELECT o.name FROM ColNames o WHERE o.cpos<>t.cpos\
21826 INSERT INTO ColNames(name,nlen,chop,reps,suff)\
21830 SELECT count(DISTINCT (substring(name,1,nlen-chop)||suff) COLLATE NOCASE)\
21831 <count(name) FROM ColNames\
21836 (substring(name,nlen,1) BETWEEN '0' AND '9')\
21837 AND (rtrim(name,'0123456790') glob '*"AUTOCOLUMN_SEP"'),\
21838 nlen-length(rtrim(name, '"AUTOCOLUMN_SEP"0123456789')),\
21846 WHERE substring(t.name,1,t.nlen-t.chop)=substring(d.name,1,d.nlen-d.chop)\
21875 " iif(t.name IN (SELECT * FROM RepeatedNames),"
21877 " t.name, substring(printf('%.*c%0.*d',nlz+1,'0',$1,t.cpos),2)),"
21878 " t.name"
21881 " iif(o.name IN (SELECT * FROM RepeatedNames),"
21883 " o.name, substring(printf('%.*c%0.*d',nlz+1,'0',$1,o.cpos),2)),"
21884 " o.name"
21892 " suff = iif(name IN (SELECT * FROM RepeatedNames),"
21907 SELECT cpos, printf('\"%w\"',printf('%!.*s%s', nlen-chop,name,suff)) AS cname \
21912 " printf('\"%w\" to \"%w\"',name,printf('%!.*s%s', nlen-chop, name, suff)),"
22412 ** only dump data for tables for which either the table name matches
22414 ** a virtual table for which the name matches the LIKE pattern.
22417 "name LIKE %Q ESCAPE '\\' OR EXISTS ("
22419 " name LIKE %Q ESCAPE '\\' AND"
22421 " substr(o.name, 1, length(name)+1) == (name||'_')"
22451 "SELECT name, type, sql FROM sqlite_schema AS o "
22511 sqlite3_exec(p->db, "SELECT name FROM sqlite_schema LIMIT 1", 0, 0, 0);
22625 ** of the option name, or a numerical value. */
22733 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
22735 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_schema) "
22736 "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
22744 " WHERE name GLOB 'sqlite_stat[134]'",
22795 char *zFullTabName; /* Table name with schema if applicable */
23107 " WHERE name='%q' AND type='index'"
23110 " WHERE name='%q' AND type='table'"
23714 ** name exactly as it appears in the query. (ex: $abc, @def). The
23763 /* If no command name matches, show a syntax error */
23986 " name text,\n"
24001 rc = sqlite3_prepare_v2(p->db, "SELECT name FROM pragma_database_list",
24023 appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
24035 " UNION ALL SELECT shell_module_schema(name),"
24036 " 'table', name, name, name, 9e+99, 'main' FROM pragma_module_list",
24061 appendText(&sSelect, "name NOT LIKE 'sqlite_%%' AND ", 0);
24288 /* If no command name matches, show a syntax error */
24486 zSql = "SELECT lower(name) FROM sqlite_schema"
24491 zSql = "SELECT lower(name) FROM sqlite_schema"
24493 " AND name NOT LIKE 'sqlite_%'"
24510 appendText(&sQuery,"SELECT type,name,tbl_name,sql FROM sqlite_schema"
24511 " ORDER BY name;", 0);
24513 appendText(&sQuery,"SELECT name,seq FROM sqlite_sequence"
24514 " ORDER BY name;", 0);
24680 appendText(&s, "SELECT name FROM ", 0);
24684 appendText(&s, "||'.'||name FROM ", 0);
24690 " AND name NOT LIKE 'sqlite_%'"
24691 " AND name LIKE ?1", 0);
24832 ** of the option name, or a numerical value. */
25770 "FILENAME is the name of an SQLite database. A new database is created\n"
25970 /* If the SQLITE_SHELL_DBNAME_PROC macro is defined, then it is the name
25971 ** of a C-function that will provide the name of the database file. Use
25981 ** the name of the database file, the name of the initialization file,
26121 /* If the SQLITE_SHELL_INIT_PROC macro is defined, then it is the name
26160 ** files from being created if a user mistypes the database name argument
26476 ** Returns a pointer to the given DB name's VFS. If zDbName is 0 then
26477 ** "main" is assumed. Returns 0 if no db with the given name is
26506 ** Returns the filename of the given db name, assuming "main" if