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

[CODE=sql]exec sp_helpconstrai nt tablename[/CODE]

[japuentem]

try executing this

[CODE=sql]exec sp_helpconstrai nt tablename[/CODE]

Thanks, that's what i'm lookinf for