Hello there.
Welcome to this video.
Describe describe is askew our command used to provide a description for a database table of view.
So if you are not sure what this truck.
Sure.
Off a table looks like a.
Command you we use to find that out will be the described command.
So let's show you a quick example how that's done.
All right.
I've got term taught for a call Ed open.
I'm just going to show an example of how you use the Describe command.
So you begin by type in the word describe followed by the name of the table you're trying to get the
information from.
So always put a semicolon at the end of your statement.
So a routine the key word describe employees is the name on the table.
So if I execute this it should provide new information about the table
thinking about it.
All right.
They will go.
So these is the structure of the table tells me the column leaves in the column names for the table
the primary keys and other information relevant to their table.
So this is where you find any information relating to the table.
Okay so that's how you would use to describe.
There is also a short form of this.
You can also use the word
D C followed by the name on the table.
Let's use a different table this time.
The Countries table.
So execute that.
Thinking.
A big answer.
Provide me provide information about their countries table told me he's got these other columns country
the country name region primary key country.
The primary key so gives me various informations about it if need to check if the tables constraint
I can click on to constraints.
Part of it tells me there is a constraint in position 1.
Okay which is in the column.
All right so that's how you would use describe command to get information relating to the table structure.
Okay this was a nice quick brief video on describe in this video I give an explanation of how to use
to describe equipment and also should an example use in a couple of tables.
I hope this information has been useful.
Thank you so much as always for watching this video and hope to see you soon.
Bye for now.