我试图在Python中创建和重新创建索引,但当我使用它时,我遇到了一个错误。
Error:
File "srcpymssql.pyx", line 468, in pymssql.Cursor.execute
pymssql.OperationalError: (7999, b"Could not find any index named 'Micros' for table
'payrolldata'.DB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages
from the SQL Servern")
代码:
with pymssql.connect ("127.0.0.1","arcdbadmin", "@rcT3chn010g13$","Micros") as myDbConn:
with myDbConn.cursor(as_dict=True) as cursor:
cursor.execute("""create index Micros on payrolldata(stono,payrollid,busdate) WITH(DROP_EXISTING = ON);""")
myDbConn.commit()
除非索引已经存在,否则不能使用 WITH(DROP_EXISTING = ON)
。
您可以先删除索引(如果存在(:
drop index if exists Micros on payrolldata
如果你愿意的话,先来。在旧版本上,您可以运行
if exists (select * from sys.indexes where name = 'Micros' and object_id('payrolldata') = object_id)
begin
drop index micros on payrolldata
end