0 - 4 of 4 tags for key

I'm logged in with dbc user.
I'm ALTERing a table to add Foreign Key Constraint with Following statement
ALTER TABLE testdb.Master2 ADD CONSTRAINT fk_Master1 FOREIGN KEY (Master1ID) REFERENCES testdb.Master1(Master1ID);
its works fine.
But when i write this in a procedure

I want to Update a table. But before that i want disable foreign key\check Constraint\Unique Key on some tables.
After update, i want to enable those disables constraint again.
Can you please tell me how can i do that.

Hi All,
I have a table that has a composite key defined on 2 columns.
These column are not a part of primary index.
The table contains data.
I am trying to drop primary key using the following command and getting a systax error :
alter table person_mst drop primary key (id,name);

Can any one tell me what is the difference between key and index?

what is the difference between primary key and unique primary key?

Ashok Reddy Daggula