Just because you don't see a diagram does not mean the relationships are not there. SQL Server builds foreign key indices to related tables. There are several ways to see these. One way is to right-click on the child table and select what I believe is called "Script 'create table' to new query. That will write the SQL for creating the table. You will see the code for creating the foreign key to the parent table.
--
Regards,
Bill Mosca
Hi,
I have upsized my back-end database access with the microsoft 'Microsoft SQL Server Migration Assistant for Access' utility everything works well (with minor modifications to the code).
I did a test by deleting a record of a table that had 1-N relationship with other tables. The operation has erased all records rightly related .. my question is: did the microsoft utility also migrate the schema of relationships? because I do not see any schema in the front-end that in the server sql
Thank you very much and I hope I have been clear.
Posted by: =?UTF-8?B?QmlsbCBNb3NjYQ==?= <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar