DBMS PRATICLE 1:- DATA DEFINATION LANGUAGE

PRATICLE 1:- DATA DEFINATION LANGUAGE

SQL> create table practicle257(rollno int primary key,name varchar(30) not null);

Table created.

SQL> insert into practicle257 values(1,'mayank sharma');

1 row created.

SQL> insert into practicle257 values(2,'aditya lohia');

1 row created.

SQL> select * from practicle257;

ROLLNO NAME
------------- ------------------------------
1 mayank sharma
2 aditya lohia

SQL> alter table practicle257 add(address varchar(20));

Table altered.

SQL> select * from practicle257;

ROLLNO NAME ADDRESS
---------- ------------------------------ --------------------
1 mayank sharma
2 aditya lohia

SQL> alter table practicle257 drop column address;

Table altered.

SQL> select * from practicle257;

ROLLNO NAME
------------ ------------------------------
1 mayank sharma
2 aditya lohia