---
# System prepended metadata

title: Car Table

---

## Rowaida AlOkka 220182247 

### 1. Drop last_name column
```sql=
ALTER TABLE owner DROP last_name;
```


### 2. Change first_name to full_name
```sql=
ALTER TABLE owner CHANGE first_name full_name VARCHAR(20);
```


### 3. Add City != Gaza Constraint
```sql=
ALTER TABLE owner ADD CONSTRAINT city_cons CHECK (city != 'Gaza');
```

### 4. Set Default Number
```sql=
ALTER TABLE owner ALTER phone_number SET DEFAULT '0591234567';
```



# Car Table
### 1. Table Before Editing



### 2. Remove Auto Incremeant
```sql=
ALTER TABLE car CHANGE id id int(11);
```

### 3. Drop Primary Key
```sql=
ALTER TABLE car DROP PRIMARY KEY;
```

### 4. Allow model_name to be NULL
```sql=
ALTER TABLE car MODIFY model_name VARCHAR(10) NULL;
```





