Create a student table and describe the schema of the student table
Dept varchar(10), City varchar(15), DOB date, Gender char(1)
QUERY*
create table student (Rollno number(6), Name varchar(15),
Dept varchar(10), City varchar(15), DOB date, Gender char(1));
- Add foreign key constraint for the column rollno from studmarks that refers rollno from student table. QUERY*
alter table student add foreign key (Rollno) references stu_marks(Rollno);
desc student;
alter table student drop column City;
Comments
Post a Comment