以SQL Server为例，检查索引是否存在，如果不存在，则创建索引

IF NOT EXISTS (select 1

  from sys.indexes I

  INNER JOIN sys.tables T ON I.object_id = T.object_id

  INNER JOIN sys.schemas S ON S.schema_id = T.schema_id

  where I.Name = 'Index_Name' -- Index name

  AND T.Name = 'Table_Name' -- Table name

  AND S.Name = 'Schema_Name') --Schema Name

create INDEX Your_New_Index ON Schema_Name.Table_Name(Column)

GO

参考资料

How to check if an Index exists in Sql Server

————————————————

版权声明：本文为CSDN博主「zLulus」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。

原文链接：https://blog.csdn.net/sinat_23050697/article/details/129392755