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.

MS Sql Server LazyDBA home page