I will call you back again for another video lecture on PostgreSQL.
And in this video lecture, I'll go ahead and teach you how to drop a column in PostgreSQL.
So the goal of this lecture is to learn how to drop any of this column or Javier.
We have our first name.
We have last name, GP, uh, enrolled date and email.
So go ahead and drop the GP.
All right.
And I'll go ahead and show you how to do that.
You can do that from the graphical interface.
Or you can go ahead and do that with a SQL show.
And for me to do that I'll first show for today table so or to table.
And uh that is students.
Then I'm going to use the drop keyword and I'm going to select a column.
Then I'll give the name of the column I want to drop as GP.
And if I hit enter that column is dropped or to table.
And let's go right here and uh refresh this and select this.
I'll go ahead and remove this.
Then let's go ahead and select all.
Go ahead and run this query.
And now you can see that this uh column for GP does no longer exist because I've already removed it.
So this is how we can actually drop a column in PostgreSQL.
So go ahead and use this.
You can actually run this from the graphical interface.
Or you run that from the SQL shell.
And one of them is cool.
Go ahead and check it out.
And if you have any question or had I 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.