Write MySql command to create the table DEPARTMENT with given constraints.
Write MySql command to create the table DEPARTMENT with given constraints.
| COLUMN_NAME | DATATYPE(SIZE) | CONSTRAINT |
| DepartmentlD | Int (4) | Primary Key |
| DepName | Varchar (50) | Not Null |
| ManagerID | Char (4) | |
| Location | Varchar (30) |
4 views
1 Answers
CREATE TABLE DEPARTMENT (DepartmentlD INT(4) PRIMARY KEY DepName VARCHAR(50) NOT NULL, ManagerlD CHAR(4), Location VARCHAR(30));
4 views
Answered