Sql Server 数据库中的所有已定义的唯一约束 (列名称 合并过了)-CSDN博客
阿里云国内75折 回扣 微信号:monov8 |
阿里云国际,腾讯云国际,低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号:monov8 飞机:@monov6 |
查询Sql Server Database中的唯一约束
with UniqueBasic as
(
SELECT
tab.name AS TableName,
idx.name AS UniqueName,
col.name AS UniqueFieldName
FROM
sys.indexes idx
JOIN sys.index_columns idxCol
ON (idx.object_id = idxCol.object_id
AND idx.index_id = idxCol.index_id
AND idx.is_unique_constraint = 1)
JOIN sys.tables tab
ON (idx.object_id = tab.object_id)
JOIN sys.columns col
ON (idx.object_id = col.object_id
AND idxCol.column_id = col.column_id)
)
SELECT A.TableName,A.UniqueName,
(
SELECT UniqueFieldName+',' FROM UniqueBasic t1 WHERE t1.UniqueName=A.UniqueName FOR XML PATH('')
) AS UniqueFieldNames
FROM UniqueBasic A
WHERE A.UniqueName = 'Qywx_App_UniqueAgentId'
GROUP BY A.TableName,A.UniqueName
附录
阿里云国内75折 回扣 微信号:monov8 |
阿里云国际,腾讯云国际,低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号:monov8 飞机:@monov6 |