WEBVTT

00:07.640 --> 00:10.910
I will call you back again for another video lecture on PostgreSQL.

00:10.910 --> 00:15.800
And in this video lecture, I'll go ahead and teach you how to drop a column in PostgreSQL.

00:16.160 --> 00:21.080
So the goal of this lecture is to learn how to drop any of this column or Javier.

00:21.110 --> 00:22.400
We have our first name.

00:22.400 --> 00:26.300
We have last name, GP, uh, enrolled date and email.

00:26.330 --> 00:27.950
So go ahead and drop the GP.

00:28.100 --> 00:28.730
All right.

00:28.730 --> 00:30.440
And I'll go ahead and show you how to do that.

00:30.440 --> 00:32.450
You can do that from the graphical interface.

00:32.450 --> 00:35.150
Or you can go ahead and do that with a SQL show.

00:35.150 --> 00:40.820
And for me to do that I'll first show for today table so or to table.

00:40.820 --> 00:43.340
And uh that is students.

00:43.340 --> 00:49.520
Then I'm going to use the drop keyword and I'm going to select a column.

00:49.520 --> 00:52.400
Then I'll give the name of the column I want to drop as GP.

00:52.460 --> 00:56.870
And if I hit enter that column is dropped or to table.

00:56.870 --> 01:03.080
And let's go right here and uh refresh this and select this.

01:03.110 --> 01:04.400
I'll go ahead and remove this.

01:04.400 --> 01:07.070
Then let's go ahead and select all.

01:07.100 --> 01:09.110
Go ahead and run this query.

01:09.110 --> 01:17.690
And now you can see that this uh column for GP does no longer exist because I've already removed it.

01:17.690 --> 01:22.640
So this is how we can actually drop a column in PostgreSQL.

01:22.640 --> 01:24.830
So go ahead and use this.

01:24.830 --> 01:27.980
You can actually run this from the graphical interface.

01:27.980 --> 01:31.400
Or you run that from the SQL shell.

01:31.430 --> 01:32.960
And one of them is cool.

01:32.990 --> 01:34.220
Go ahead and check it out.

01:34.220 --> 01:38.600
And if you have any question or had I use the question and answer section and I'm going to get back

01:38.600 --> 01:40.070
to you as soon as possible.

01:40.100 --> 01:41.060
Thank you so much.

01:41.060 --> 01:44.570
And I'm going to see you in the next video lecture.