Board index » cppbuilder » Change Index ?

Change Index ?


2005-12-13 09:10:58 PM
cppbuilder81
Hello,
Is any command for change index , like ALTER TABLE for tables ?
Best regards,
m.t
 
 

Re:Change Index ?

Quote
Is any command for change index , like ALTER TABLE for tables ?
That would depend on the dbms involved. For MS sql server, the answer is
no. You must drop and then create the index (at least as far as v2000 is
concerned).