Home » SQL & PL/SQL » SQL & PL/SQL » How to alter index
How to alter index [message #348707] Wed, 17 September 2008 13:48 Go to next message
vamcs
Messages: 20
Registered: June 2007
Location: somerset
Junior Member

How to alter index example is
un1 -- index name
xx_test -- Table name
a1,a2,a3 are the column names of table xx_test

create unique index un1 on xx_test (a1)
can i know how can i alter index un1 on a1 to un1 (a1,a2,a3) on table xx_test

Thanks in Advance
Re: How to alter index [message #348709 is a reply to message #348707] Wed, 17 September 2008 14:22 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't. You have to recreate the index.

Regards
Michel
Previous Topic: Select into problem
Next Topic: write a calendar
Goto Forum:
  


Current Time: Sat Dec 10 01:13:02 CST 2016

Total time taken to generate the page: 0.09968 seconds