Find tables in a Microsoft SQL Server database without a primary key defined

tables-without-a-primary-key.sql

SELECT 
	S.name AS SchemaName
	,T.name AS TableName

FROM sys.tables AS T
	INNER JOIN sys.schemas AS S ON ( T.schema_id = S.schema_id )

WHERE NOT EXISTS ( 
		SELECT *
		FROM sys.indexes AS I
		WHERE I.object_id = T.object_id
			AND I.is_primary_key = 1
	)
	
ORDER BY S.name, T.name;