# Re: 资料汇出&更改索引栏资料

Posted by 纪文和 on July 20, 1998 at 16:59:24:

In Reply to: 资料汇出&更改索引栏资料 posted by Gail on July 19, 1998 at 23:11:14:

: 如过我要将已有索引已存在的的Table，将索引值重新编号或修改，要如何移除旧索引，插入新索引??

Dim DB As Database
Dim wsql As String
Set DB = opendatabase("xxx.mdb")
'移除Index
wsql = "DROP INDEX MyIndex on TableName;"
DB.Execute wsql
'新增Index
wsql = "CREATE INDEX Index1 on TableName(Field)"
DB.Execute wsql

Follow Ups: