Sql query for list out all tables which has not any primary key in sql server

Write a sql query or script to get or list out all tables in a database which has not any primary key in sql server

SELECT name 
FROM sys.tables t 
WHERE  NOT EXISTS(SELECT  1 
   FROM  sys.indexes i 
   WHERE  t.object_id = i.object_id 
     AND is_primary_key = 1)