BP2- Create - Alter
Database
Created Date
08.22.20
Last Updated
08.25.20
Viewed 10 Times
Create multiple-choice games on Wisc-Online and play them on our Chakalaka mobile app!
But that's not all! Explore educational games created by others. Simply search by category or enter agame code number and dive into a world of learning and fun.
Download the Chakalaka mobile app here:
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
User comments are currently unavailable. We apologize for the inconvenience and are working to restore this feature as soon as possible.