Re: Help with Delete query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Diego F. (diegofrNO_at_terra.es)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 15:22:13 +0200

Yes, is what you say. I want to delete the customer, but mantain the entries
in the orders table. 

-- 
Saludos,
Diego F.
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió
en el mensaje news:OtVZjwojEHA.536@TK2MSFTNGP11.phx.gbl...
> So, as an example, your Orders table has a foreign key to the Customers
table. And you want to
> delete a customer. This is what foreign key are there for. Or are you
saying that it is the
> opposite. Try to describe your problems using the terms "referencing" and
"referenced" table. Makes
> it easier to understand. In my example, Orders is the referencing table,
and Customers is the
> Referenced table. Or, if it is easier for you, you could post (simplified)
DDL.
>
> -- 
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Diego F." <diegofrNO@terra.es> wrote in message
news:eNp8ZpojEHA.384@TK2MSFTNGP10.phx.gbl...
> > Hi. I'm trying to build the delete query from a database.
> >
> > The problem is that the item I try to delete has a column that is the
> > foreign key of another table and it doesn't allow me to do that. Why
not?
> >
> > I don't want to delete the items from the other table where it's the
foreing
> > key.
> >
> > Regards,
> >
> > Diego F.
> >
> >
>
>

Relevant Pages

  • Re: Help with Delete query
    ... created the foreign key between the tables in the first pace, as this is exactly what the foreign key is there ... You can create a "dummy" customer and update the order so they refer to that dummy customer. ... In my example, Orders is the referencing table, ... >>> Diego F. ...
    (microsoft.public.sqlserver.programming)
  • Re: Help with Delete query
    ... Is there any problem having a detail table without foreing key? ... > So as I understand it, you want to have orders for which the customer ... > created the foreign key between the tables in the first pace, ... >> Diego F. ...
    (microsoft.public.sqlserver.programming)
  • Re: Help with Delete query
    ... I would not want to have orders for which I don't know which customer to ship them to. ... foreign key, ... > that dummy customer. ... >>> Diego F. ...
    (microsoft.public.sqlserver.programming)
  • RE: DB Design for a Service Company...
    ... Clicking the + shows all sites for each customer. ... Simple table detailing supplier names, addresses, product/service provided. ... which will contain the same number as the primary key (from ... you use the same name for the foreign key as you used for the primary key. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Get data from combo box to popluate the next box
    ... corresponding table by linking the tables in a query by the common field. ... When the customer is entered on the form via the ... If data is entered into the control, ... the corresponding foreign key field in the underlying table. ...
    (microsoft.public.access.forms)