Can anyone help me with regards to a contraint that is a foreign key? I have several tables that all need to reference another table, so the several tables all have a foreign key constraint:
ALTER TABLE tblOne
ADD CONSTRAINT FK_ForeignKeyID
FOREIGN KEY (the_referenced_id) REFERENCES tblReferencedTable(the_referenced_id)
Should I create the above constraint for each table I need it applied to, or can I just create the constraint and then add it to each table?
Many thanks to anyone who can help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!