SQL Tutorial - 50: Views in SQL (Part-3) Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 50th tutorial in this course and in
this tutorial we are going to wrap up
our discussion on muse and this is
probably going to be a short tutorial so
what I'm going to show you guys in this
tutorial is how you execute the update
query with views and how you can remove
views from your database right so the
update query works pretty much the same
way for views as it as it does for
tables and to update a value in a view
you have to type in the update keyword
and then you have to follow that up with
the the name of the view so I will
update a row in the EMP underscore view
view that I created a couple of
tutorials ago and what I'll do is I'll
change the value of the name field to a
value in the name field to Bond right so
we're set name equals bond
where the ID value is 1917 right so when
I execute the query remember that in the
last role we inserted a row with ID 1970
and in that row we inserted the value
Craig for the name field so when I would
execute the select star from EMP
underscore view query I see that for the
row with ID 1917 I have the value born
now instead of Craig right so that's how
the update query works and you know we
can also check out the delete statement
you know and in fact the delete
statement works the same way you know as
it does with tables you know it works
the same way for views and if you want
to remove the row with ID 1917 from the
from the table and the view as well then
you will execute the lead from EMP
underscore view where ID equals 1917 so
when you would execute this query
you know you won't yet but result set
but in the output section you will see
the message that one row was affected
and ill
statement was executed successfully
right so next what we're going to check
out is how you can remove a view from a
table and just as you use the drop table
command to drop tables you use the drop
view command to drop views so if suppose
you want to drop the view EMP underscore
view from the database then you type in
drop space view space the name of the
view which is EMP underscore view and
when you execute it you see that again
you don't see a result set but in the
output section you get the message that
the view was dropped successfully and if
you try to run a select star from the
view now then you would get netted EMP
underscore view and there you go we see
in the output section that the table
eeehm test dot EMP underscore view or
the view EMP underscore view doesn't
exist right so that's it for now and in
the next tutorial we are going to check
out some aggregate functions and thank
you so much for watching this one and
you may subscribe to my channel in case
you haven't already and I'll see you
soon