Identify tables without primary key

Rajzz

How to identify list of tables with doesnt have PK in its DDL ? 

FiliN

Did you check

 

select * from v_catalog.tables t where t.table_name not in
(
select table_name from v_catalog.primary_keys
)

 

?