Name: Mayank
Section: 6
Admission No.: 20SCSE1010447
EXPERIMENT No. 2
Objective: Study of Data Definition Language – Create Table, Alert Table, Drop Table, Rename table.
Theory: The SQL DDL allows specification of not only a set of relations but also information about each
relation, including-
• Schema for each relation
• The domain of values associated with each attribute.
• The integrity constraints.
• The set of indices to be maintained for each relation.
• The security and authorization information for each relation.
The physical storage structure of each relation on disk.
Syntax:
1. Create Table: -
create table emp1(E_ID int, E_Name char, E_Dept char,E_DOB
date,Salary int);
2. Alter Table: -
alter table emp1 drop column salary;
