Question

Ravi wants to see the whole structure of relation titled as “CAR” which have already been developed In MYSQL in the current database. What query should he write.​

Answer 1

He should use the following command to view the structure of the relation 'CAR'.

$\tt Desc\ Car;$

Explanation:

$\tt Desc$ is a command that is used to view the structure of the table/relation formed, or rather as the command suggests, "describe" the table/relation. This means that it shows the various field names, the data types of each field, whether they support null values or not, if they have a primary key or not, etc.

For example, when the $\tt Desc$ command is passed for a table named 'Grocer' [attachment 1], the output would look like this [attachment 2].