set oSQLServer =server.createobject("SQLDMO.SQLServer")oSQLServer.Connect "数据库IP,端口","用户名","密码" '''' 连接数据库
set tables =server.createobject("SQLDMO.Table")Set tables = oSQLServer.Databases("数据库名").Tables("表名")
set idxProductName =server.createobject("SQLDMO.Index")idxProductName.Name = "索引名"idxProductName.FileGroup = "文件组"idxProductName.Type = 索引类型idxProductName.IndexedColumns = "[字段名]"
tables.Indexes.Add idxProductName
SQLDMOIndex_Clustered SQLDMOIndex_Default SQLDMOIndex_DRIIndex SQLDMOIndex_DRIPrimaryKey SQLDMOIndex_DRIUniqueKey SQLDMOIndex_DropExist SQLDMOIndex_Hypothetical SQLDMOIndex_IgnoreDupKey SQLDMOIndex_NoRecompute SQLDMOIndex_PadIndex SQLDMOIndex_SortedData SQLDMOIndex_SortedDataReorg SQLDMOIndex_Unique SQLDMOIndex_Valid
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18