tajidner_2170

create table employee2170 (emp_id varchar(10) primary key,city varchar(15) not null,salary varchar(10),age varchar(10),email_id varchar(35),check(age>17),designation varchar(10) default (AP));

insert into employee2170 (emp_id,city,salary,age,email_id)values(11412170,'goraya',100000,19,'tajinder.jhally@gmail.com');
insert into employee2170 (emp_id,city,salary,age,email_id)values(11412171,'jalandhar',10000,21,'taj.jhally@gmail.com');
insert into employee2170 (emp_id,city,salary,age,email_id)values(11412173,'chandighard',200000,19,'jinder.jhally@gmail.com');
insert into employee2170 (emp_id,city,salary,age,email_id)values(11412174,'delhi',500000,19,'lalit.jhally@gmail.com');

alter table employee2170 add name varchar(15)

select * from employee2170

update employee2170  set name ='tajinder' where emp_id = 11412170;
update employee2170  set name ='taj' where emp_id = 11412171;
update employee2170  set name ='jinder' where emp_id = 11412173;
update employee2170  set name ='lalit' where emp_id = 11412174;
update employee2170  set name ='revo' where emp_id = 11412172;

------------------------------------------------------------------------------------------------------

create table customer2170 (c_id varchar(10) primary key,name varchar(10),city varchar(10));


insert into customer2170 (c_id,name,city)values(11412170,'tajinder','goraya');
insert into customer2170 (c_id,name,city)values(11412171,'taj','jalandhar');
insert into customer2170 (c_id,name,city)values(11412172,'jinder','chaard');
insert into customer2170 (c_id,name,city)values(11412173,'lalit','delhi');

-----------------

create table order2170 (o_id varchar(10) primary key,o_no varchar(20),c_id varchar(10),foreign key(c_id) references customer2170 (c_id));


insert into order2170 values(1412170,'a0',11412170);
insert into order2170 values(1412171,'a2',11412171);
insert into order2170 values(1412172,'a3',11412173);
insert into order2170 values(1412173,'a4',11412170);


=--------------------

alter table order2170 drop primary key;

alter table order2170 add primary key (o_id);

alter table order2170 add constraint c_id primary key(c_id);

alter table order2170 drop constraint ... ;

---

select age from table_name between 20 and 30;