我如何获得在SQL Server 2000中特定列已存在的唯一约束 [英] How can i get unique constraints that has existed particular column in sql server 2000

问题描述

我的表有5个字段并且有一个列存在唯一约束(即，名称列是唯一键)
如何通过SQL Server 2000中的查询获取名称"列的唯一约束?
请帮助我解决上述问题....

My table have 5 fields & there have a column is exist unique constraints(i.e. Name column is unique key)
How can i get unique constraints of ''Name'' column through query in sql server 2000???

Please help me any instruction for above problem....

推荐答案

此处:
SQL-如何获取唯一密钥"表中的列名 [ ^ ]

像这样的东西:

Here:
SQL - How to get the Unique Key''s Column Name from Table[^]

Something like:

select CCU.CONSTRAINT_NAME, CCU.COLUMN_NAME
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS as TC
inner join INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE as CCU
    on TC.CONSTRAINT_CATALOG = CCU.CONSTRAINT_CATALOG
    and TC.CONSTRAINT_SCHEMA = CCU.CONSTRAINT_SCHEMA
    and TC.CONSTRAINT_NAME = CCU.CONSTRAINT_NAME
where TC.CONSTRAINT_CATALOG = 'MyCatalogName'
and TC.CONSTRAINT_SCHEMA = 'MySchemaName'
and TC.TABLE_NAME = 'MyTableName'
and TC.CONSTRAINT_TYPE = 'UNIQUE'

这篇关于我如何获得在SQL Server 2000中特定列已存在的唯一约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！