>The documentation seems to say that I can set a 1 to 1 relationship between tables with the command "Alter Table table1 references table2". However this gives me a syntax error, as does "alter table table1 references table2 tag mytag". Can anyone tell me what the syntax of the command to establish a 1 to 1 relationship between 2 tables with primary keys in a DBC? Thanks.
looks like it would be something like:
ALTER TABLE Table1 ADD FOREIGN KEY KeyExpression TAG TagName1 REFERENCES Table2 TAG TagName2
just from scratching my head over the docs...
Jim Newsom
IT Director, ICG Inc.