relationships in SQL

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 19:56
Joined
Sep 12, 2006
Messages
16,121
can you establish RI in a SQL backend - or is RI enforced in the front end
 
I do not understand this question, SQL server IS a backend product there is no front end??

or are you not asking a SQL server question?
 
As SQL_Hell alluded, SQL Server is your backend now. In Access, you had two files, one front-end and one back-end. You enforced RI in Access back-end.

You replace the Access back-end with SQL Server... but RI still stays in the SQL Server. Access front-end (or indeed, ANY front-end clients) cannot ever enforce RI for any database.
 
I couldn't see any obvious tools in SQL (MySql) to mange RI. I was using HeidiSQL - but I will also try the MySQL Workbench.

I will search again, as there is obviously something there.
 

Users who are viewing this thread

Back
Top Bottom