Pentru a obţine lista tabelelor care nu au primary key poţi folosi următorul query:

SELECT name FROM sysobjects WHERE xtype='U' AND id NOT IN (
    SELECT parent_obj FROM sysobjects WHERE xtype='PK'
) AND OBJECTPROPERTY(id,'IsMSShipped')=0

Răzvan