Lines Matching refs:create
23 # trig-1.9: Ensure that we cannot create a trigger on sqlite_master
125 } {1 {cannot create trigger on system table}}
133 create table t1(a,b);
138 create trigger r1 after delete on t1 for each row begin
148 create table t1(a,b);
153 create trigger r1 after update on t1 for each row begin
162 # Ensure that we cannot create INSTEAD OF triggers on tables
165 create table t1(a,b);
166 create trigger t1t instead of update on t1 for each row begin
170 } {1 {cannot create INSTEAD OF trigger on table: t1}}
171 # Ensure that we cannot create BEFORE triggers on views
174 create view v1 as select * from t1;
175 create trigger v1t before update on v1 for each row begin
179 } {1 {cannot create BEFORE trigger on view: v1}}
180 # Ensure that we cannot create AFTER triggers on views
184 create view v1 as select * from t1;
185 create trigger v1t AFTER update on v1 for each row begin
189 } {1 {cannot create AFTER trigger on view: v1}}
428 # example, that you can drop and re-create tables referenced by triggers.
499 # Drop and re-create the insert_log table in a different database. Note