How to get Foreign keys

select name from sysobjects where type='U' and name not in(
SELECT  Distinct table_name 
FROM information_schema.key_column_usage 
WHERE constraint_catalog = db_name()
AND lower(constraint_name)  like 'pk%'
AND table_name not like 'tbl_core_%' 
        AND table_name not like 'db_version_1%'
        AND table_name not like 'dtproperties' 
AND LOWER(constraint_name)  like 'pk%')
order by name