Today I wanted to pull this info to work on a replication strategy and the below code shows how to do that in a matter of seconds

-- Find all tables that don't have a Primary Key
select nameFROM SysObjects WHERE xtype='U'AND id NOTIN (SELECT parent_obj FROM SysObjects WHERE xtype='PK')