Board index » delphi » Can not delete primary key

Vladimir

Delphi Developer
Wed, 19 May 2004 00:11:57 GMT

Can not delete primary key

I can not delete primary key. Following message come up :  Cannot delete index used by an Integrity Constraint

Vlad

 
Marcio Barros

Delphi Developer
Wed, 19 May 2004 00:38:43 GMT

Re:Can not delete primary key


Are you using something like

ALTER TABLE <TableName> DROP CONSTRAINT <ConstraintName>.

If not, you should be.

If you are, check all the constraints to make sure there isn't any
dependencies with other tables.

HTH,

Mrcio Barroso

Vladimir <v.obou...@claimsecure.com> escreveu nas notcias de
mensagem:3c07afcd$1_2@dnews...

Quote

> I can not delete primary key. Following message come up :  Cannot delete

index used by an Integrity Constraint
Quote

> Vlad

Other Threads

1. Primary key or not primary key.........

2. preventing entries being deleted when primary key is deleted

3. Delete a record in a TDBGrid with the Delete Key (and not Ctrl-Delete)

4. Deleting Primary key

5. It's not bad canned meat...

6. 'Could not find PRIMARY KEY...

7. guid field in ms sql server as primary key not unique

8. sorry,i have not set the primary key.

9. Primary key not showed in IBX Delphi component

10. dbExpress does not supprot mySQL AUTO_INCREMENT primary key ???