UNIQUE KEY [message #591706] |
Wed, 31 July 2013 02:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a017a6304efa4dfa61de60fa24733d4c?s=64&d=mm&r=g) |
satheesh_ss
Messages: 61 Registered: July 2012
|
Member |
|
|
Hi this is my table structure...
mysql> desc one
-> ;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| empno | int(11) | NO | UNI | NULL | |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
I want to remove UNIQUE KEY from the above table.
How can i drop unique key from the table.
|
|
|
|
|
Re: UNIQUE KEY [message #593141 is a reply to message #591709] |
Wed, 14 August 2013 09:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/287ad74c449db772d3f07eb57649008b?s=64&d=mm&r=g) |
satheeshsharma
Messages: 11 Registered: August 2013 Location: Chennai
|
Junior Member |
|
|
i didn't mention any constraint name for the check constraint...I simple used UNIQUE at the time of column creation...Hope u understand wat i am saying....
If that is the case, how can i drop UNIQUE constraint from the column...here i didnt give any index name...
[Updated on: Wed, 14 August 2013 09:40] Report message to a moderator
|
|
|
|