drop primary key

[virginie]

hi

i have to delete the primary key through code ( in sql in ms access 2000)
so i try the query : ALTER TABLE Table1 DROP PRIMARY KEY
in sql first to see if it's work before doing this through code.
BUT :i get a "syntax error in alter statement"
and the word PRIMARY is indicated.
someone understand WHY??
THANKS A LOT IF SOMEONE CAN HELP.

VIRGINIE

 

[LittleSmudge]

Try using the field name for the Primary key field not the 'Primary Key' attribute.

ALTER TABLE Table1 DROP FieldNameForPrimeKey


G LS

 

[AWithers]

I think it should read

ALTER TABLE Table1 DROP CONSTRAINT PRIMARY KEY


Andy

 

[LittleSmudge]

But doesn't DROP CONSTRAINT just remove the attribute from the field ?
I think Virginie wants to totally get rid of the field - attributes, name, data and all.


G LS

 

[virginie]

i wanted to leave the field but remove the fact that it is a key.

i try both solutions but it not gives more results...

PRIMARY is maybe not a reserved word in access , so it pass for a name of column??

 

[ClydeDoggie]

Why do you have to use SQL? Try SQLDMO, set a variable to the Table you want to change and use the Keys collection to remove it. If you don't know what I am talking about set a reference to Microsoft SQLDMO library and use the Object Browser to see the objects that are exposed.