Create a table studmarks with following attributes name and data type.
Rollno number (6), Regnumb number(14), semester number(1), cgpa number (5) and perform some other operations.
QUERY*Create table studmarks (rollno number(6), regnumber number(14), semester number(1), cgpa number(5));
Desc studmarks;
As Shown Fig...2.1
-
Alter the table:
- Add the constraints UNIQUE for regnumber attribute from table. QUERY*
- Remove the constraints for the regnumber attribute.
- Modify the data type of regnumber to varchar(16).
Alter table studmarks modify (regnumber number(14) UNIQUE);
As Shown Fig...2.2
Comments
Post a Comment