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




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: 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)
  • Re: C# / SQL Related - whats wrong with this Insert Into syntax?
    ... Strange little problem here... ... I'm getting a "Syntax error in Insert Into statement" when it ... tries to execute the SQL. ... execute it using the MS Access query engine, ...
    (microsoft.public.dotnet.languages.csharp)

Loading