Hi people,
I'm strating to use mSQL and would like to know if mSQL supports Foreign
Keys and if it performs the consistency check when u try to insert a
value that doesn't exist in the table that has the original values.
Like this: I have a table with customers
-Customer
CustID (unique, sequence.. )
...
-Orders
OrderID
CustID (FK)
...
I try to insert a new order and in this order I have the wrong or a
different CustID, what will happen when I try to insert this line onto
the orders table?
Thanks,
Fabio
fabiob@xway.com.br
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:04:03 EST