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.