Lines Matching refs:UNIQUE

6512 ** in a UNIQUE index.  This is the way PostgreSQL, Oracle, DB2, MySQL,
6517 ** a UNIQUE index.  In this mode, you can only have a single NULL entry
6518 ** for a column declared UNIQUE.  This is the way Informix and SQL Server
8848 ** a UNIQUE constraint violation are removed so that the new insert or
8955   u8 autoIndex;    /* True if is automatically created (ex: by UNIQUE) */
61895 ** has a UNIQUE constraint or UNIQUE index.
64875   /* Check that the new column is not specified as PRIMARY KEY or UNIQUE.
64884     sqlite3ErrorMsg(pParse, "Cannot add a UNIQUE column");
67314   ** PRIMARY KEY or UNIQUE keywords are parsed.  Those keywords will cause
68828 ** UNIQUE constraint.  If pTable and pIndex are NULL, use pParse->pNewTable
68954   ** dealing with a primary key or UNIQUE constraint.  We have to invent our
69123     ** result of a PRIMARY KEY or UNIQUE clause on a column definition, or
69124     ** a PRIMARY KEY or UNIQUE clause following the column definitions.
69128     ** CREATE TABLE t(x, y, UNIQUE(x, y));
69135     ** Two UNIQUE or PRIMARY KEY constraints are considered equivalent
69211   ** or UNIQUE constraint of a CREATE TABLE statement.  Since the table
69236         onError==OE_None ? "" : " UNIQUE",
69240       /* An automatic index created by a PRIMARY KEY or UNIQUE constraint */
69366     sqlite3ErrorMsg(pParse, "index associated with UNIQUE "
72935 ** table are collectively subject to a UNIQUE or PRIMARY KEY constraint.
72958 **      UNIQUE or PRIMARY KEY constraint, or
73019       /* pIdx is a UNIQUE index (or a PRIMARY KEY) and has the right number
75078 ** CHECK, and UNIQUE constraints are all checked.  If a constraint fails,
75106 **  UNIQUE           REPLACE      The other row that conflicts with the row
75279   /* Test all UNIQUE constraints by creating entries for each UNIQUE
75308       continue;  /* pIdx is not a UNIQUE index */
75596   int destHasUniqueIdx = 0;        /* True if pDest has a UNIQUE index */
75732     ** Or if the destination has a UNIQUE index and is not empty,
78473     ** was created to be the PRIMARY KEY or to fulfill a UNIQUE
85678       "SELECT 'CREATE UNIQUE INDEX vacuum_db.' || substr(sql,21) "
85679       "  FROM sqlite_master WHERE sql LIKE 'CREATE UNIQUE INDEX %'");
88103 ** ASC or DESC.  (Terms of the ORDER BY clause past the end of a UNIQUE
88222     ** and the index is UNIQUE and no terms on the tail of the ORDER BY
91786   "UNIQUE",        "CHECK",         "REFERENCES",    "AUTOINCR",    
91897  /*  65 */ "ccons ::= UNIQUE onconf",
91927  /*  95 */ "tcons ::= UNIQUE LP idxlist RP onconf",
92077  /* 245 */ "uniqueflag ::= UNIQUE",
93110       case 65: /* ccons ::= UNIQUE onconf */
93171       case 95: /* tcons ::= UNIQUE LP idxlist RP onconf */
93735       case 245: /* uniqueflag ::= UNIQUE */
94520       testcase( i==46 ); /* UNIQUE */