Re: Query to add Foreign Key constraint to existing tables?

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


Francisco Garcia wrote:
> I get a "Syntax error in CONSTRAINT
> clause", and the DELETE word is automatically selected

You may need to execute it via the OLE DB provider e.g. in Access2000
VBA use

CurrentProject.Connection.Execute "ALTER TABLE ..."

.

Relevant Pages

  • Re: Tadoquery problem
    ... > I get a "Syntax error near FROM clause" when i try to execute the ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: What is the technique to supply a list of values to a where clause?
    ... the where clause has a "column in list" clause. ... When I try to run the code, DBI returns an error saying that the value ... execute with 10 variables when 2 were needed. ... element in the ArrayTupleStatus and in some cases it does not help ...
    (perl.dbi.users)
  • Re: Continuing Autonumber from where I left off
    ... Perhaps not but Jeff Boyce Microsoft Office/Access MVP was. ... "You can use NOT NULL on a single field or within a named ... multiple-field named CONSTRAINT." ... including Standard SQL) a NOT NULL clause is not a CONSTRAINT, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: user permissions
    ... I would like to add some comments regarding 'EXECUTE AS' clause in SQL ... Server 2005 as a complement of Rick's response. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Do all the legs of an "OR" with null comparisons get executed?
    ... I did MMDDOB=1231, whenever MMDDOB was NULL the row would be filtered ... The WHERE clause is not working the way you expect, ... Placing as Oracle would evaluate the WHERE clause: ... going to execute something that reads ...
    (comp.databases.oracle.server)