# Adjusting Required Licenses

Defaultly, vehicles in vms\_vehicleshopV2 have been set to require licenses under the names used in VMS Schools V2. If you do not use our schools or want to remove the license requirement in a very easy way using one line to the database, read the following guide along with ready-made queries.

***

{% tabs %}
{% tab title="Rename required licenses" %}

```sql
// The following SQL code will change the license.
// Change 'NEW_LICENSE_NAME' to your license name that you are using.
// Change 'drive_b' to the license you want to remove, e.g. 'drive_b', 'practical_plane'.

UPDATE vehicles SET `requiredLicense` = 'NEW_LICENSE_NAME' WHERE `requiredLicense` = 'drive_b';
```

{% endtab %}

{% tab title="Remove all required licenses" %}

```sql
// The following SQL code will remove all required licenses.

UPDATE vehicles SET `requiredLicense` = NULL WHERE `requiredLicense` IS NOT NULL;
```

{% endtab %}

{% tab title="Remove for specific license" %}

```sql
// The following SQL code will remove the specific license.
// Change 'drive_b' to the license you want to remove, e.g. 'drive_b', 'practical_plane'.

UPDATE vehicles SET `requiredLicense` = NULL WHERE `requiredLicense` = 'drive_b';
```

{% endtab %}
{% endtabs %}