Untitled text

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