Topics of this game:
- create table t1 ( a1 number(2) primary key, a2 nvarchar(10) not null, a3 timestamp not null);
- create table t1 ( a1 char(5) primary key, a2 nvarchar(10) not null primary key, a3 date not null);
- alter table t1 add a1 number(3) ;
- alter table t1 drop column a1;
- drop column a1 from table t1;
- add column a1 to table t1;
- delete table t1;
- create table t1 ( a1 char(10), a2 number(5), a3 date unique, constraint t1_pk primary key (a1));
- create table t1 ( a1 number(2), a2 nvarchar(10) unique, a3 timestamp);
- alter table t1 modify a1 char(10);
- change a1 to char(10);
- alter table t1 add a1 timestamp;
- alter table t1 add constraint c1 foreign key references t2 (a2);
- add constraint unique to table t1;
- alter table drop unique;
- 4
- 6
- 7
- 8
- 9
