CREATE TABLE Student (
Student_ID INT Primary Key,
Name VARCHAR (30),
Age INT,
City VARCHAR(50)
);

INSERT INTO Student VAlUES
(2,'Ram',18,'Pune'),
(3,'Riya',20,'Nashik'),
(4,'Sita',23,'Surat'),
(5,'Shyam',28,'Pune');

Select * from Student;

Update Student
SET City ='Delhi'
where Student_ID=5;

Delete FROM Student
Where Student_ID=4;

Alter Table Student
ADD EMAIL VARCHAR(100);

ALTER TABLE Student Add Phone Varchar(15);
Alter TABLE Student ALTER COLUMN Phone VARCHAR (20);
GO
EXEC sp_rename 'Student','StudentDetails';
GO