Thread: Check integrity
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:33 PM
Dmitri Shvetsov
 
Posts: n/a
Default Check integrity

Hi,

What methods can we use to check the integrity problems? Some records in my
database are having Foreign Keys but the database doesn't have any related
records with required Primary Keys. I need to scan the whole database and
delete (maybe with backup, maybe not) all wrong records.

Who can I do that? Is it need to write my own application to do that or we
have some standard way to fix these problems? I'm not a database
administrator and don't know these ways (yet). Can somebody help me with
advice?

Thanks.

Dmitri Shvetsov



Reply With Quote