Syntax : CREATE VIEW VIEW_NAME AS SELECT Column_Name1 , Column_Name2 From Table_Name Where “Condition”. |
Query : CREATE VIEW Details AS SELECT * From student_details Where Marks>50; |
NOTE : The above query will create a view named as “Details” containing records having marks>50 from student_details table.
Syntax : UPDATE VIEW_NAME SET Condition Where “Existing Values/Conditions”; |
Query : UPDATE Details SET Marks = 95 Where Name = ”Rakesh”; |
NOTE : The above query will update value in marks in the previously created “Details” View.
Syntax : DROP VIEW VIEW_NAME; |
Query : DROP VIEW Details; |
NOTE :