Lines Matching refs:ALTER

14 # "ALTER TABLE ... ADD COLUMN".
39 # alter3-1.*: Test that ALTER TABLE correctly modifies the CREATE TABLE sql.
62   execsql {ALTER TABLE abc ADD d INTEGER;}
68   execsql {ALTER TABLE abc ADD e}
76     ALTER TABLE t1 ADD c;
82     ALTER TABLE t1 ADD d CHECK (a>d);
90       ALTER TABLE t2 ADD c REFERENCES t1(c)  ;
98     ALTER TABLE t3 ADD COLUMN c VARCHAR(10, 20);
120     ALTER TABLE t1 ADD c PRIMARY KEY;
125     ALTER TABLE t1 ADD c UNIQUE
130     ALTER TABLE t1 ADD b VARCHAR(10)
135     ALTER TABLE t1 ADD c NOT NULL;
140     ALTER TABLE t1 ADD c NOT NULL DEFAULT 10;
179     ALTER TABLE t1 ADD c;
215     ALTER TABLE t1 ADD c DEFAULT 'hello world';
253       ALTER TABLE aux.t1 ADD COLUMN c VARCHAR(128);
276       ALTER TABLE aux.t1 ADD COLUMN d DEFAULT 1000;
328       ALTER TABLE t1 ADD COLUMN c DEFAULT 'c';
346         ALTER TABLE abc ADD d DEFAULT NULL;
352         ALTER TABLE abc ADD e DEFAULT 10;
358         ALTER TABLE abc ADD f DEFAULT NULL;
383       ALTER TABLE t4 ADD c$i
397 # violations in ALTER TABLE ADD COLUMN
405   ALTER TABLE t1 ADD COLUMN c CHECK(a!=1);
408   ALTER TABLE t1 ADD COLUMN c CHECK(a!=3);
411   ALTER TABLE t1 ADD COLUMN c CHECK(a!=2);
414   ALTER TABLE t1 ADD COLUMN d AS (b+1) NOT NULL;
417   ALTER TABLE t1 ADD COLUMN d AS (b+1) NOT NULL CHECK(a!=1);
420   ALTER TABLE t1 ADD COLUMN d AS (b+1) NOT NULL CHECK(a!=3);
431   ALTER TABLE t0 ADD COLUMN xtra1 AS (n+1) NOT NULL CHECK(m!=1);
434   ALTER TABLE t0 ADD COLUMN xtra1 AS (n+1) NOT NULL CHECK(m!=3);
437   ALTER TABLE t2 ADD COLUMN xtra1 AS (y+1) NOT NULL CHECK(x!=1);
440   ALTER TABLE t2 ADD COLUMN xtra1 AS (y+1) NOT NULL CHECK(x!=3);