Re: ADOX not deleting on first attempt

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On May 8, 11:38 pm, "Stephen Howe" <stephenPOINThoweATtns-
globalPOINTcom> wrote:
Problem is, it takes a couple of "runs" to delete all the table.
Is there a reason for this?

Foreign Key violations?

Stephen Howe

Unfortunatelly not Setephen, I make sure I drop all indexes and
constraints before dropping the table.
.

Relevant Pages

  • Re: moving indexes
    ... output sql to drop ref constraints, ... run 2nd script on what's left, ... No. Dropping things is a subject I haven't dealt with enough. ... the references constraint info for those referenced by foreign keys only ...
    (comp.databases.informix)
  • Re: [patch 134/149] x86, paravirt: Add a global synchronization point for pvclock
    ... On Tue, 13 Jul 2010, Avi Kivity wrote: ... My bet is that dropping 'static' will fix it. ... The constraints are there, but maybe the toolchain is confused. ...
    (Linux-Kernel)
  • Re: Drop all user tables + ignore constraints
    ... Uh, how about drop database, re-create, and re-create the tables? ... far easier to script out than dropping all those constraints and tables in ... and it gives errors until we drop the constraints. ...
    (microsoft.public.sqlserver.programming)
  • Re: modifying relationships using DAO?
    ... The DDL statements run just the same as a DAO QueryDef. ... Lyle Fairfield wrote: ... Constraints as in: ... (dropping the existing constraint) ...
    (comp.databases.ms-access)