Below query can be used to get list of tables without having primary key in SQL Server.

use DBNAME /** replace your database name here **/
go
select s.[name] + N'.' + t.[name] [Table]
from sys.tables t
inner join sys.schemas … Read the rest