If you would ever, from whatever reason, need to check/validate/list foreign keys in the MS SQL 2000/2005 database, here is the magical query you won't find on msdn: SELECT sysforeignkeys.constid, sysforeignkeys.fkeyid, sysforeignkeys.rkeyid, sysobjects.name as keyname, soFK.name AS firsttable, soRK...