Re: ADOX not deleting on first attempt

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: 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)
  • Re: how to drop constraints
    ... The syntax for dropping a constraint is: ... "tchangmian" wrote in message ... > constraints within the table while the table is not been dropped. ...
    (microsoft.public.sqlserver.programming)
Quantcast