Monday, April 18, 2011

DATABASE DESIGN LANGUAGE - COMMANDS



create db SKYNET

connect to SKYNET

create table STUDENTDB (SN integer not null,ROLLNO varchar(7) not null unique, NAME varchar(25) not null,M1 integer check (M1>0),M2 integer check (M2>0),M3 integer check (M3>0),M4 integer check (M4>0),M5 integer check (M5>0),M6 integer check (M6>0))

select * from STUDENTDB

alter table STUDENTDB add TOTAL integer

select * from STUDENTDB

alter table STUDENTDB add DOB date

select * from STUDENTDB

alter table STUDENTDB add DEPT varchar(3) check (DEPT in ('CSE' ,'IT'))

select * from STUDENTDB

drop table STUDENTDB

Your's friendly,
[MOHANRAM.G],
ADMIN...

0 comments:

Post a Comment