I'm getting an error in deleting a record from Customers table (or other tables such as Categories) in Northwind database of SQL Server, due to foreign key constraint. How can I solve it? Thanks a lot!
I am unfamiliar with this Northwind db and I have never use SQL Server (even though I have it on CD somewhere...).
I know that you can find the reationships with MySQL with this: SHOW TABLE STATUS FROM your_db_name [like 'tabe_name'];
I don't know what the SQL Server command is for the same thing. I noticed MySQL does things a little differently from my time using Oracle.
__________________ eak | "Doing a good deed is like wetting your pants; every one can see the results, but only you can feel the warmth."