Constraint Syntax Error?

Ö

Özden Irmak

Hello,

I got syntax error on this constraint clause pointing the [NO INDEX] :

ALTER TABLE [Title Author] ADD CONSTRAINT
[{BD291498-E5FD-11CF-80D3-00AA00C0094F}] FOREIGN KEY [NO INDEX] ([ISBN])
REFERENCES [Titles] ([ISBN]);

According to Jet Sql 4.0 reference this should be working.Anyboy can help
me?

Thanks in advance,

Özden
 
B

Brian Camire

You might try:

ALTER TABLE [Title Author] ADD CONSTRAINT
[{BD291498-E5FD-11CF-80D3-00AA00C0094F}] FOREIGN KEY NO INDEX ([ISBN])
REFERENCES [Titles] ([ISBN]);

In other words, remove the square brackets around "NO INDEX".

Also, you have to execute statements with the "NO INDEX" keywords through
the Jet OLE DB Provider -- for example, using
CurrentProject.Connection.Execute.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add constraint returns syntax error on constrain clause 7
Droping constraint 3
Using DDL to Create Constraint - Syntax Error 4
Setting Relationship with CONSTRAINT clause causing error? 6
Syntax error in CONSTRAINT 1
Cascade delete 1
ALTER TABLE syntax 2
CREATE table sql - constraint syntax error 2

Top