主键与计算列


--主键表
SELECT TOP 50 * 
FROM sys.key_constraints

--没有主键的表
SELECT TOP 50 * 
FROM sys.tables a
WHERE a.object_id NOT IN(
	SELECT parent_object_id
	FROM sys.key_constraints
)
    
    
	SELECT TOP 50 * 
	FROM sys.parameters 

--查询计算列
SELECT TOP 50 * 
FROM sys.computed_columns