Question

Write SQL command to create the table VEHICLE with given constraint.

| COLUMN_NAME | DATATYPE( SIZE) | CONSTRAINT |
| RegNo | CHAR(10) | Primary Key |
| Regdate | DATE | |
| Owner | VARCHAR(30) | |
| Address | VARCHAR(40) | |

Answer 1

CREATE TABLE VEHICLE (RegNo CHAR(10) PRIMARY KEY Regdate DATE, Owner VARCHAR(30), Address VARCHAR(40);