当前位置:Gxlcms > 数据库问题 > sqlserver如何判断某字段做唯一索引,而且是单独

sqlserver如何判断某字段做唯一索引,而且是单独

时间:2021-07-01 10:21:17 帮助过:5人阅读

  1. IF (
  2. SELECT COUNT(*) FROM sys.index_columns
  3. INNER JOIN sys.indexes ON indexes.index_id = index_columns.index_id AND indexes.object_id = index_columns.object_id
  4. INNER JOIN sys.columns ON columns.column_id = index_columns.column_id AND columns.object_id = indexes.object_id
  5. WHERE indexes.object_id=OBJECT_ID(N‘dbo.tblEnh_SuppQuo‘, N‘U‘) AND indexes.is_unique=1 AND columns.name =N‘InternalQuoNo‘
  6. )=1
  7. BEGIN
  8. SELECT 1
  9. END

 

或者

  1. IF (
  2. SELECT COUNT(*) FROM sys.index_columns
  3. INNER JOIN sys.indexes ON indexes.index_id = index_columns.index_id AND indexes.object_id = index_columns.object_id
  4. INNER JOIN sys.columns ON columns.column_id = index_columns.column_id AND columns.object_id = indexes.object_id
  5. INNER JOIN sys.objects ON objects.object_id = indexes.object_id
  6. WHERE objects.name=N‘tblEnh_SuppQuo‘ AND objects.schema_id=1 AND objects.type=N‘U‘ and indexes.is_unique=1 AND columns.name =N‘InternalQuoNo‘
  7. )=1
  8. BEGIN
  9. SELECT 1
  10. END

  

sqlserver如何判断某字段做唯一索引,而且是单独

标签:ble   unique   alq   schema   name   highlight   column   sch   如何   

人气教程排行