1
00:00:00,390 --> 00:00:00,960
Hello there.

2
00:00:00,960 --> 00:00:03,080
Welcome to this video.

3
00:00:03,390 --> 00:00:14,540
Describe describe is askew our command used to provide a description for a database table of view.

4
00:00:14,730 --> 00:00:18,060
So if you are not sure what this truck.

5
00:00:18,060 --> 00:00:18,430
Sure.

6
00:00:18,430 --> 00:00:20,390
Off a table looks like a.

7
00:00:20,400 --> 00:00:24,720
Command you we use to find that out will be the described command.

8
00:00:24,720 --> 00:00:27,560
So let's show you a quick example how that's done.

9
00:00:28,140 --> 00:00:28,540
All right.

10
00:00:28,560 --> 00:00:32,380
I've got term taught for a call Ed open.

11
00:00:32,400 --> 00:00:37,560
I'm just going to show an example of how you use the Describe command.

12
00:00:37,650 --> 00:00:45,300
So you begin by type in the word describe followed by the name of the table you're trying to get the

13
00:00:45,300 --> 00:00:48,370
information from.

14
00:00:55,630 --> 00:00:59,380
So always put a semicolon at the end of your statement.

15
00:00:59,530 --> 00:01:04,640
So a routine the key word describe employees is the name on the table.

16
00:01:04,660 --> 00:01:10,990
So if I execute this it should provide new information about the table

17
00:01:13,440 --> 00:01:15,060
thinking about it.

18
00:01:17,050 --> 00:01:17,520
All right.

19
00:01:17,520 --> 00:01:18,060
They will go.

20
00:01:18,060 --> 00:01:25,620
So these is the structure of the table tells me the column leaves in the column names for the table

21
00:01:26,700 --> 00:01:33,880
the primary keys and other information relevant to their table.

22
00:01:33,900 --> 00:01:38,060
So this is where you find any information relating to the table.

23
00:01:38,580 --> 00:01:41,680
Okay so that's how you would use to describe.

24
00:01:41,790 --> 00:01:44,310
There is also a short form of this.

25
00:01:44,310 --> 00:01:46,530
You can also use the word

26
00:01:49,660 --> 00:01:54,560
D C followed by the name on the table.

27
00:01:57,060 --> 00:02:01,220
Let's use a different table this time.

28
00:02:01,680 --> 00:02:03,530
The Countries table.

29
00:02:03,830 --> 00:02:06,190
So execute that.

30
00:02:11,590 --> 00:02:12,440
Thinking.

31
00:02:12,740 --> 00:02:13,390
A big answer.

32
00:02:13,400 --> 00:02:21,980
Provide me provide information about their countries table told me he's got these other columns country

33
00:02:22,190 --> 00:02:26,860
the country name region primary key country.

34
00:02:27,110 --> 00:02:34,290
The primary key so gives me various informations about it if need to check if the tables constraint

35
00:02:34,720 --> 00:02:36,170
I can click on to constraints.

36
00:02:36,170 --> 00:02:41,170
Part of it tells me there is a constraint in position 1.

37
00:02:41,670 --> 00:02:43,730
Okay which is in the column.

38
00:02:44,050 --> 00:02:53,550
All right so that's how you would use describe command to get information relating to the table structure.

39
00:02:54,960 --> 00:03:04,580
Okay this was a nice quick brief video on describe in this video I give an explanation of how to use

40
00:03:04,580 --> 00:03:10,190
to describe equipment and also should an example use in a couple of tables.

41
00:03:10,190 --> 00:03:12,120
I hope this information has been useful.

42
00:03:12,140 --> 00:03:16,520
Thank you so much as always for watching this video and hope to see you soon.

43
00:03:16,520 --> 00:03:17,970
Bye for now.