Trying To Find Tabes Without Primary Keys

I wrote a query that when run, will give me a listing of all tables in a database, and whether or not those table have primary keys.

Here's the query:




Code Snippet
select so.name, si.name from sysobjects so
left outer JOIN sysindexes si on so.id = si.id
where si.status = '2066' and so.type = 'u'
order by so.name asc


It works for the most part save for one small (big) problem. It gives me a list of tables that have a corresponding primary key, but doesn't list those without one. For example, in one database I run this query. I know for a fact that there are 26 tables in this database, and my query returns 16 rows (one for each table with a PK). I'd like to see those as well as those without one, with a NULL in the NAME column for the PK.

I've tried every join combo under the sun and still can't get the desired results.

Any insight would be appreciated!

Thanks!