How to remove the primary key?

[Jigs]

Hi All,

I have one serious emergency.

I have 2 options (2 qeustions) in front of me.

[1] How can I remove primary key and not the column
[2] How can I rename the column which is primary key.

Please help me.

Thanks in advance

Jigs

 

[lcross]

when entering in design mode there is a button with a key select the column and click the button then rename it.

 

[Jigs]

I mean using SQL Query

I want to remove primary key constraint using SQL Query and I also wanted to rename the column which is primary key using SQL query.

 

[neileg]

[1] Why would you want to return a column with no entries? I don't understand - just don't return the column in your query.
[2] To change the name, use the AS operator in your SQL, tblMyTable.PKField AS NewFieldName