I am trying to alter primary key using Query in access but getting the 
syntax error. I am trying:

ALTER TABLE Table1 DROP PK_TABLE1;

It is giving me error on PK... Can anybody help me in this regard.

Thanks,
Maqsood Ahmed