Write a DDL statement for

Question

cid, integer, primary key
cname, varchar, <25
age, integer, >10
DOB, date, no blank value,
address, varchar, default value Kathmandu

Answer 1

CREATE TABLE Personnel (
cid int not nullPRIMARY KEY,
cname varchar(25) not null,
age int not null check > 10,
DOB date not null,
address varchar (50) default kathmandu,
PrimaryKey (cid));