|
Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software
to find all unique indexes which are not
primary keys. Unique indexes can be used to enforce entity integrity on natural keys such as product name.
use AdventureWorks;
select
IndexName = i.Name,
SchemaName = schema_name(schema_id),
TableName = object_name(o.object_id)
from sys.indexes i
join sys.objects o
on i.object_id = o.object_id
where is_primary_key = 0
and is_unique = 1
and o.object_id in
(select object_id from sys.objects where type='U')
order by SchemaName, TableName, IndexName
|
