Unique Key

Dear experts,
if i've created one unique key on one column, will it creates an index on that? if so, is there any way to find how every index was created?

i mean wether it was created with create index or it was created while the primary key or unique key creation.


thank you very much....i've been using the PBGUY query


Select * from

(select object_name(si.id) [Object],index_col(object_name(si.id), si.indid, sk.keyno) [Column_Name],

case when (si.status & 16)<> 0 then 'clustered'

else 'nonclustered' end [Index Type]

from sysindexes si join sysindexkeys sk

on si.id = sk.id and si.indid = sk.indid and si.indid between 1 and 254 and (si.status & 64)=0 ) as b
where Column_Name is not null


thank you very much