The error message you're seeing, ORA-01735, is an Oracle SQL error that indicates you're trying to use an invalid option with the ALTER TABLE command.

In your case, you're trying to drop a primary key from the BORROWERS table. However, the syntax you're using is incorrect. You cannot drop a primary key in Oracle using the ALTER TABLE command directly.

Here's how you can do it:

1. First, you need to find the name of the 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';
```

2. Once you have the constraint name, you can drop the primary key using the following command:

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

Replace "constraint_name" with the actual name of the constraint you found in step 1.

Question

The error message you're seeing, ORA-01735, is an Oracle SQL error that indicates you're trying to use an invalid option with the ALTER TABLE command.

In your case, you're trying to drop a primary key from the BORROWERS table. However, the syntax you're using is incorrect. You cannot drop a primary key in Oracle using the ALTER TABLE command directly.

Here's how you can do it:

1. First, you need to find the name of the 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';
```

2. Once you have the constraint name, you can drop the primary key using the following command:

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

Replace "constraint_name" with the actual name of the constraint you found in step 1.

Knowee AI · Accepted Answer

The error message you're seeing, ORA-01735, is an Oracle SQL error that indicates you're trying to use an invalid option with the ALTER TABLE command.

In your case, you're trying to drop a primary key from the BORROWERS table. However, the syntax you're using is incorrect. You cannot drop a primary key in Oracle using the ALTER TABLE command directly.

Here's how you can do it:

1. First, you need to find the name of the 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';
```

2. Once you have the constraint name, you can drop the primary key using the following command:

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

Replace "constraint_name" with the actual name of the constraint you found in step 1.

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