In this video, we go ahead and learn how to delete a rule from a table in PostgreSQL.
So we have this rule.
We have a Sarah and we have another Sarah here.
And how to delete maybe the ID for or ID five.
So let me go ahead and delete the ID five.
And if I want to do that I can actually do that from the pgadmin.
And then I can also do that right from here.
Now how can I delete that code here?
I say delete that is a keyword.
And we are going to delete from a students.
And then you're going to give a where clause where I say where and I'll go ahead.
And that semi-abstract ID or anything you need or where the first name is Sarah.
So but if I delete the first name is Sarah, I'm going to delete both are the these two I'm going to
delete both of them.
So I'm going to use where this ID is equal to five because now we specify I want to delete just the
fifth one and we are stress id equal to five.
And go ahead and hit enter and delete one.
Now if I go ahead and refresh this go ahead and check out these.
Now Excel application has lost database connection.
Go ahead and now.
Check it out.
So now we have been able to connect back.
And then you can see that our the student ID five has been deleted.
Another way I can also delete any of these.
So this is a way you can actually delete anything from meal or table.
Right.
This is a we can actually delete a record from this place and that actually works fine.
So go ahead and check it out.
Practice with it.
And if you have any question go ahead and use the question and answer section.
And I'm going to get back to you as soon as possible.
Thank you so much.
And I'm going to see you in the next video lecture.