Question

Rohan is learning to work upon Relational Database Management System (RDBMS) application. Help him to perform the following task:

To display the structure of the table "BOOKS" existing in the already opened database "LIBRARY".

Answer 1

Rohan needs to use the following command to show the arrangement of the table books that are currently in the database library that is open:

DESC BOOKS;

Explanation: The SQL DESCRIBE TABLE command is responsible for providing information about a particular database table. The SQL command DESCRIBE or another keyword DESC, which is the same as DESCRIBE, is used to display the structure of a database table or tables on the server.