find a primary key

[japuentem]

Hi all

i want to know if i can show with a sql sentence in my query analizer the primary key of one table

i know sp_columns '@table' show me the columns of my table but i want to know if one of the columns are primary key

thanks

[debasisdas]

try executing this

exec sp_helpconstraint tablename

[japuentem]

try executing this

exec sp_helpconstraint tablename

Thanks, that's what i'm lookinf for