以SQL Server為例，檢查索引是否存在，如果不存在，則創(chuàng)建索引

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

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

版權(quán)聲明：本文為CSDN博主「zLulus」的原創(chuàng)文章，遵循CC 4.0 BY-SA版權(quán)協(xié)議，轉(zhuǎn)載請附上原文出處鏈接及本聲明。

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