Should I create relationships in my code? or on my SQL server?

[michaaal]

Should I create database relationships in my code (ASP)? Or in my SQL
server?

Thanks

 

[John Vinson]

Should I create database relationships in my code (ASP)? Or in my SQL
server?

Thanks

I'd say in the SQL server. That's what it's designed to do: no point
in reinventing the wheel. Besides, if the relational constraints are
in your code, there'd be nothing to prevent someone from opening the
tables using a different application and entering invalid data; your
code would be powerless to prevent it.

 

[michaaal]

I'd say in the SQL server. That's what it's designed to do: no point

in reinventing the wheel. Besides, if the relational constraints are
in your code, there'd be nothing to prevent someone from opening the
tables using a different application and entering invalid data; your
code would be powerless to prevent it.

Good point, but on the other hand, if there was a problem with the way SQL
handled my data then I would be powerless in fixing the problem....not that
that's likely