how do i find out all of the primary keys on all tables of a db

[Manhattan2002]

I was wondering whether there's an alternative to
typing sp_helpconstraint on every table?

How can you find out which tables have primary key constraints etc?

Thanks

JG

 

[suchetan]

Hi

You can use the following sql
select name from sysindexes where status &2048=2048


Reagards

suchetan