Question

Write SQL command to perform the following operation on table
STUDENT:
(a) To view the structure of table STUDENT.
(b) To view all the contents of the table STUDENT.
(c) To delete the table STUDENT from database.​

Answer 1

Answer:

A OPTION IS THE CORRECT ANSWER

Answer 2

SQL COMMANDS

Explanation:

(a) To view the structure of a particular table i.e. attributes . We use

COMMAND-  desc STUDENT;

(b) To view the contents(values) you entered in a particular Table .We use

COMMAND-  select * from STUDENT;

(c) If you want to delete your content (values) as well as structure of that particular table from database.We use

COMMAND-  drop table STUDENT;