Hi friends,
A pleasant greetings for one and all.I have the table
which name is ALA.It has a column id.i set id as primary key.Can any
one help me .please.

i tried this query but no use,,,

alter table ala drop primary key;

mada suresh wrote:
ALTER TABLE dbo.ALA
DROP CONSTRAINT name_of_primary_key_constraint

If relationships/foreign keys referencing this column exist, you will likely
have to drop those as well.

And to find out the name_of_primary_key_constraint you can use this:
SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE LOWER(TABLE_NAME) = 'ala' AND CONSTRAINT_TYPE = 'PRIMARY KEY'

Best,
Henk

On 28-03-2011 15:56, Bob Barrows wrote: