The error message you're seeing is due to incorrect syntax in your SQL command. In Oracle SQL, you cannot drop a primary key constraint using the ALTER TABLE command without specifying the constraint name.

Here's how you can do it:

1. First, you need to find the name of the primary key constraint. You can do this by running the following command:

```sql
SELECT constraint_name
FROM user_constraints
WHERE table_name = 'BORROWERS' AND constraint_type = 'P';
```

This will return the name of the primary key constraint on the BORROWERS table.

2. Once you have the constraint name, you can drop it using the ALTER TABLE command. Replace 'constraint_name' with the actual name of your constraint:

```sql
ALTER TABLE BORROWERS DROP CONSTRAINT constraint_name;
```

Please replace 'constraint_name' with the actual name of the constraint you obtained from the first step. This will drop the primary key constraint from the BORROWERS table.

Question

The error message you're seeing is due to incorrect syntax in your SQL command. In Oracle SQL, you cannot drop a primary key constraint using the ALTER TABLE command without specifying the constraint name.

Here's how you can do it:

1. First, you need to find the name of the primary key constraint. You can do this by running the following command:

```sql
SELECT constraint_name 
FROM user_constraints 
WHERE table_name = 'BORROWERS' AND constraint_type = 'P';
```

This will return the name of the primary key constraint on the BORROWERS table.

2. Once you have the constraint name, you can drop it using the ALTER TABLE command. Replace 'constraint_name' with the actual name of your constraint:

```sql
ALTER TABLE BORROWERS DROP CONSTRAINT constraint_name;
```

Please replace 'constraint_name' with the actual name of the constraint you obtained from the first step. This will drop the primary key constraint from the BORROWERS table.

Knowee AI · Accepted Answer

The error message you're seeing is due to incorrect syntax in your SQL command. In Oracle SQL, you cannot drop a primary key constraint using the ALTER TABLE command without specifying the constraint name.

Here's how you can do it:

1. First, you need to find the name of the primary key constraint. You can do this by running the following command:

```sql
SELECT constraint_name 
FROM user_constraints 
WHERE table_name = 'BORROWERS' AND constraint_type = 'P';
```

This will return the name of the primary key constraint on the BORROWERS table.

2. Once you have the constraint name, you can drop it using the ALTER TABLE command. Replace 'constraint_name' with the actual name of your constraint:

```sql
ALTER TABLE BORROWERS DROP CONSTRAINT constraint_name;
```

Please replace 'constraint_name' with the actual name of the constraint you obtained from the first step. This will drop the primary key constraint from the BORROWERS table.

Error starting at line : 10 File @ /oracle.sqlIn command -alter table BORROWERS drop constraint primary key(AuthorID)Error report -ORA-01735: invalid ALTER TABLE option01735. 00000 - "invalid ALTER TABLE option"Cause: Action:

Question

Solution

Similar Questions

Upgrade your grade with Knowee

Error starting at line : 10 File @ /oracle.sqlIn command -alter table BORROWERS drop constraint primary key(AuthorID)Error report -ORA-01735: invalid ALTER TABLE option01735. 00000 - "invalid ALTER TABLE option"*Cause: *Action:

Question

Solution

Similar Questions

Upgrade your grade with Knowee

Error starting at line : 10 File @ /oracle.sqlIn command -alter table BORROWERS drop constraint primary key(AuthorID)Error report -ORA-01735: invalid ALTER TABLE option01735. 00000 - "invalid ALTER TABLE option"Cause: Action: