Examveda
Examveda

Which command is used for the table definition in Mysql?

A. DESC table_name;

B. DESC table_name

C. DESC

D. None of the mentioned

Answer: Option A

Solution(By Examveda Team)

This question is about understanding how to see the structure of a table in MySQL. Think of it like looking at the blueprint of a house.

The command DESC is used to display the definition of a table. It shows you the columns, their data types, and other properties. This is helpful when you want to understand how a table is set up.

Let's break down the options:
Option A: DESC table_name; This is the correct syntax. You use "DESC" followed by the name of your table and a semicolon at the end.
Option B: DESC table_name This is missing the semicolon, which is needed to complete the command in MySQL.
Option C: DESC This is incomplete. It needs the table name after "DESC".
Option D: None of the mentioned This is incorrect because Option A is the correct command.

So the answer is Option A: DESC table_name;

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous