DDL COMMANDS Program In RDBMS - SVRR TECH

Aim:

            To explore the simple queries with DDL commands using SQL.

Algorithm:

Step 1: Start the process.

Step 2: Using create command.

Step 3: Using insert command add record in a table.

Step 4: Explore the DDL command  to get result table.

Step 5: Get the output.

Step 6: Stop the program.

Program

Create:

create table student(regno varchar(10),Name varchar(10),age number,gender                                           varchar(10));

table created.

Alter:

alter table student  add programme varchar(10)

table altered.

Modify:

alter table student  modify programme varchar(15)

desc student

Drop:

Alter table student drop(programme);

Table altered

Drop:

            drop table student

Table dropped.