WEBVTT

00:00.090 --> 00:00.670
OK.

00:00.900 --> 00:05.990
So the last little bit of syntax we'll learn and this section has to do with deleting tables.

00:06.000 --> 00:11.390
We've seen how to create tables we've seen how to describers show their columns.

00:11.580 --> 00:13.710
We haven't seen how to put anything in those tables yet.

00:13.710 --> 00:15.900
That's coming up next in the next section.

00:16.470 --> 00:18.810
But the last thing we'll do is see how we delete them.

00:18.810 --> 00:20.910
So think to yourself for a moment.

00:21.300 --> 00:24.000
What's your guess about how you delete a table.

00:24.000 --> 00:28.310
My hint is that it's pretty similar to how we've seen how to delete something else before.

00:28.350 --> 00:29.670
In my school.

00:29.970 --> 00:30.260
OK.

00:30.280 --> 00:34.420
So think about that and I'll just wait here for a second I guess.

00:34.490 --> 00:37.610
Did you make coffee right.

00:37.680 --> 00:43.200
So the magic is drop table and then the table name.

00:43.680 --> 00:49.720
So rather than drop database we're going to say drop table and then cats.

00:49.770 --> 00:51.120
In our case.

00:51.120 --> 00:53.010
So just to prove to you that that works.

00:53.010 --> 00:54.820
Let's give it a shot.

00:55.080 --> 00:56.360
Back in cloud nine.

00:56.430 --> 00:59.730
I will type drop table.

01:00.360 --> 01:01.250
And this is permanent.

01:01.260 --> 01:03.920
It's going to disappear.

01:03.960 --> 01:05.580
It tells us queery OK.

01:06.060 --> 01:09.030
To make sure that it's actually gone.

01:09.030 --> 01:10.710
We could use a couple of different things.

01:10.710 --> 01:11.870
It's up to you.

01:11.910 --> 01:15.120
We can do show tables.

01:17.130 --> 01:18.300
And it tells us empty set.

01:18.300 --> 01:19.600
There are no tables here.

01:19.680 --> 01:26.370
Whereas before when we did that we got data and if we tried to describe cats now we get an error because

01:26.640 --> 01:31.400
cats no longer exists so it can't even show us the columns because it doesn't exist.

01:31.680 --> 01:34.080
So that's all there is to dropping or deleting a table.

01:34.080 --> 01:35.840
Very similar to dropping a database.