getting all tables with primary but no foreign keys

[stiej]

Hi,

i'm wanting to write a script to output all my user tables that have a primary key field(s), BUT also NO foreign keys in the same table.

Would any one point me in the right direction as to which tables would hold all this data for me, or any SPs that already do this?

Any help would be much appreciated.

Thanks.

 

[Jamfool]

here we go:

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'PRIMARY KEY' 
AND TABLE_NAME NOT IN
(
SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'
)

 

[stiej]

FANTASTIC! Thanks ever so much, that's a great help.