Get the columns in UNIQUE CONSTRAINT

[SteveDingle]

Hello All,

Is there a way I can find out the column(s) defined in a UNIQUE CONSTRAINT for a specific table

Thanks,
Steve

 

[vongrunt]

Yup:

select *
from information_schema.key_column_usage
where table_name = 'tablename'
	and constraint_name in
	(	select constraint_name
		 from information_schema.table_constraints
		 where constraint_type in ('UNIQUE')
	)

Wanna include primary keys as well, add [!],'PRIMARY KEY'[/!] after 'UNIQUE'

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]

 

[SteveDingle]

Thanks vongrunt. Perfect!

Would you know of a resource (online books section or whitepaper) which would give me the various ways, like this, of getting this type of information

Thanks again

Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd