A great many times in a system like this data integrity is handled by
triggers. I would see what/how many triggers are in the db.

-----Original Message-----
From: Inmon Mark
[mailto:mssqldba-ezmlmshield-x37419950.[Email address protected]
Sent: Friday, September 28, 2007 10:33 AM
To: LazyDBA Discussion
Subject: Database with out PK or FK

Guys what would you do if you have a large database without Primary keys
or foreign keys.

I have been asked to produce reports on this system but really do not
know where to start. Never seen anything like this database or how they
maintain data integrity. I called the company and talked to a SR person
and they could not answer the question. How to you maintain data
integrity in a database with out keys.

806 tables
798 have no PK
806 have no relationships
Liberty Hospital Confidentiality Notice: The information contained in
this e-mail transmission is confidential information, proprietary to the
sender and legally protected. Its purpose is intended for the sole use
of the individual(s) or entity named in the message header. If you are
not the intended recipient, you are hereby notified that any
dissemination, copying or taking any action in reliance on the contents
of this information is strictly prohibited. If you received this message
in error, please notify the sender of the error and delete this message
and any attachments.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page