Why can't I use this SQL statement in Access?

D

Dirk Goldgar

deLOL said:
"ALTER TABLE table_name DROP CONSTRAINT constraint_name"

It said that syntax error.
Click to expand...

I don't see anything wrong with it, but then, that is probably not the
actual SQL statement you tried to execute. Please post the actual
statement. If you built and executed it from code, please post the
code.
 

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

Changing the default value of a column in Access using a SQL query 1
How to drop a foreign key in Access ( I don't know the name of the relationship) 1
nested statement firing more than desired... 1
Form, 3211 Error, could not lock table, already used in form. 11
Using Append Queries with Linked Tables 3
Droping constraint 3
How to remove relationship? 4
Using DDL to Create Constraint - Syntax Error 4

Top