1
00:00:00,090 --> 00:00:00,590
Okay.

2
00:00:00,720 --> 00:00:05,640
So the last little bit of syntax we'll learn in this section has to do with deleting tables.

3
00:00:05,820 --> 00:00:07,640
We've seen how to create tables.

4
00:00:07,650 --> 00:00:11,280
We've seen how to describe or show their columns.

5
00:00:11,400 --> 00:00:13,710
We haven't seen how to put anything in those tables yet.

6
00:00:13,720 --> 00:00:15,810
That's coming up next in the next section.

7
00:00:16,410 --> 00:00:18,510
But the last thing we'll do is see how we delete them.

8
00:00:18,660 --> 00:00:20,970
So think to yourself for a moment.

9
00:00:21,090 --> 00:00:23,610
What's your guess about how you delete a table?

10
00:00:23,880 --> 00:00:29,550
My hint is that it's pretty similar to how we've seen how to delete something else before in my SQL.

11
00:00:30,270 --> 00:00:33,360
So think about that and I'll just wait here for a second.

12
00:00:33,360 --> 00:00:35,820
I guess if you make a copy.

13
00:00:36,990 --> 00:00:37,590
All right.

14
00:00:37,590 --> 00:00:43,050
So the magic is drop table and then the table name.

15
00:00:43,500 --> 00:00:50,580
So rather than drop database, we're going to say drop table and then Katz in our case.

16
00:00:51,000 --> 00:00:54,000
So just to prove to you that that works, let's give it a shot.

17
00:00:55,080 --> 00:01:01,260
Back in cloud nine, I will type drop table cats and this is permanent.

18
00:01:01,260 --> 00:01:02,370
It's going to disappear.

19
00:01:03,930 --> 00:01:08,490
It tells us query OC to make sure that it's actually gone.

20
00:01:08,910 --> 00:01:10,710
We could use a couple of different things.

21
00:01:10,710 --> 00:01:11,520
It's up to you.

22
00:01:11,760 --> 00:01:14,310
We can do show tables.

23
00:01:14,430 --> 00:01:14,880
Oops.

24
00:01:17,070 --> 00:01:18,310
And it tells us empty set.

25
00:01:18,330 --> 00:01:19,580
There are no tables here.

26
00:01:19,590 --> 00:01:22,100
Whereas before, when we did that we got data.

27
00:01:22,110 --> 00:01:28,260
And if we try to describe cats now we get an error because cats no longer exists.

28
00:01:28,260 --> 00:01:31,320
So it can't even show us the columns because it doesn't exist.

29
00:01:31,530 --> 00:01:36,030
So that's all there is to dropping or deleting a table very similar to dropping a database.