Write command to solve the given queries of table BOOK:
3 FieldName Datatype Constraint Integer (4) Primary key A varchar (20) varchar (30) float (4,2) BNO BName Author Price (a) Add a new column Publication with varchar (30) to the table BOOK. (b) Display the structure of the table BOOK.
3 FieldName Datatype Constraint Integer (4) Primary key A varchar (20) varchar (30) float (4,2) BNO BName Author Price (a) Add a new column Publication with varchar (30) to the table BOOK. (b) Display the structure of the table BOOK.
Answers & Comments
Explanation:
# To display BNO
# To display Bname
# To display Author
# To display price