Tablas sin llaves primarias

[royrojas]

En SQL 2005

Código:

SELECT * 
  FROM INFORMATION_SCHEMA.TABLES
  WHERE NOT EXISTS(SELECT * 
	FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
	WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
	AND INFORMATION_SCHEMA.TABLES.TABLE_NAME = INFORMATION_SCHEMA.TABLE_CONSTRAINTS.TABLE_NAME)
  AND TABLE_TYPE = 'BASE TABLE'