Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

Show Structure

Q:2
Show the structure of the STUDENT table.


SQL> DESC STUDENT;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ROLLNO                                    NOT NULL NUMBER(38)
 NAME                                               CHAR(25)
 SUB1                                               NUMBER(4)
 SUB2                                               NUMBER(4)
 SUB3                                               NUMBER(4)
 TOTAL                                              NUMBER(4)