Informatics Practices
Shivam wants to see the table structure in MySQL. Select an appropriate command to help him.
- Use
- Show
- Desc
- Display
Relational Database
1 Like
Answer
Desc
Reason — The DESCRIBE or DESC command is used to view a table structure in MySQL.
Answered By
3 Likes
Related Questions
Which of the following keywords is used to display non-repeated values in MySQL?
- Unique
- All
- Order by
- Distinct
The SQL statements always end with …………… .
- ,
- :
- ;
- "
Rajat wants to delete a primary key constraint from the table. Select an appropriate command to do so.
- Create
- Alter
- Drop
- Delete
Rajveer wants to rename column in display result for his query. Select the appropriate query for the same:
- Select Ename, Salary*12 Annual Salary From Emp;
- Select Ename, Salary*12 Rename "Annual Salary" From Emp;
- Select Ename, Salary*12 Change "Annual Salary" From Emp;
- Select Ename, Salary*12 as "Annual Salary" From Emp;