The error you're encountering is due to incorrect SQL syntax. The ALTER TABLE statement is used to add, delete/drop or modify columns in an existing table. You are trying to drop a primary key and add a new primary key in the same statement which is not allowed.

Here's how you can do it properly:

Step 1: First, you need to drop the existing primary key. You can do this with the following command:

```sql
ALTER TABLE USERS
DROP PRIMARY KEY;
```

Step 2: Then, you can add a new primary key to the 'Email' column with this command:

```sql
ALTER TABLE USERS
ADD PRIMARY KEY (Email);
```

Please note that the 'Email' column must be unique and not contain any NULL values, otherwise, you will not be able to set it as a primary key.

Question

The error you're encountering is due to incorrect SQL syntax. The ALTER TABLE statement is used to add, delete/drop or modify columns in an existing table. You are trying to drop a primary key and add a new primary key in the same statement which is not allowed.

Here's how you can do it properly:

Step 1: First, you need to drop the existing primary key. You can do this with the following command:

```sql
ALTER TABLE USERS
DROP PRIMARY KEY;
```

Step 2: Then, you can add a new primary key to the 'Email' column with this command:

```sql
ALTER TABLE USERS
ADD PRIMARY KEY (Email);
```

Please note that the 'Email' column must be unique and not contain any NULL values, otherwise, you will not be able to set it as a primary key.

Knowee AI · Accepted Answer

The error you're encountering is due to incorrect SQL syntax. The ALTER TABLE statement is used to add, delete/drop or modify columns in an existing table. You are trying to drop a primary key and add a new primary key in the same statement which is not allowed.

Here's how you can do it properly:

Step 1: First, you need to drop the existing primary key. You can do this with the following command:

```sql
ALTER TABLE USERS
DROP PRIMARY KEY;
```

Step 2: Then, you can add a new primary key to the 'Email' column with this command:

```sql
ALTER TABLE USERS
ADD PRIMARY KEY (Email);
```

Please note that the 'Email' column must be unique and not contain any NULL values, otherwise, you will not be able to set it as a primary key.

Error starting at line : 8 File @ /oracle.sqlIn command -alter table USERS drop primary key add primary key (Email)Error report -ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"Cause: Action:

Question

Solution

Similar Questions

Upgrade your grade with Knowee

Error starting at line : 8 File @ /oracle.sqlIn command -alter table USERS drop primary key add primary key (Email)Error report -ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:

Question

Solution

Similar Questions

Upgrade your grade with Knowee

Error starting at line : 8 File @ /oracle.sqlIn command -alter table USERS drop primary key add primary key (Email)Error report -ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"Cause: Action: