查询没有主键的表

select name from sys.tables
except
select table_name from INFORMATION_SCHEMA.TABLE_CONSTRAINTS
where CONSTRAINT_TYPE='PRIMARY KEY'