Lines Matching refs:create

22 # trigger1-1.9: Ensure that we cannot create a trigger on sqlite_master
167 } {1 {cannot create trigger on system table}}
175     create table t1(a,b);
180     create trigger r1 after delete on t1 for each row begin
191     create table t1(a,b);
196     create trigger r1 after update on t1 for each row begin
205 # Ensure that we cannot create INSTEAD OF triggers on tables
208     create table t1(a,b);
209     create trigger t1t instead of update on t1 for each row begin
213 } {1 {cannot create INSTEAD OF trigger on table: t1}}
216 # Ensure that we cannot create BEFORE triggers on views
219     create view v1 as select * from t1;
220     create trigger v1t before update on v1 for each row begin
224 } {1 {cannot create BEFORE trigger on view: v1}}
225 # Ensure that we cannot create AFTER triggers on views
229     create view v1 as select * from t1;
230     create trigger v1t AFTER update on v1 for each row begin
234 } {1 {cannot create AFTER trigger on view: v1}}
547 # example, that you can drop and re-create tables referenced by triggers. 
617   # Drop and re-create the insert_log table in a different database. Note