Question

Write SQL query to create a table “BOOKS” with the following structure:

Table: BOOKS

| Field name | Datatype | Size | Constraint |
| BOOK_ID | Integer | 2 | Primary Key |
| BOOK_NAME | Varchar | 20 | |
| CATEGORY | Varchar | 10 | |
| ISSUE_DATE | Date | | |

Answer 1

Create table Books

(

BOOK_ID Integer (2) Primary Key,

BOOK_NAME Varchar (20),

CATEGORY Varchar (20),

ISSUE_DATE Date

);