Access Database 2016 syntax error in CONSTRAINT clause
0
I was running this SQL create table in access 2016 database but I get syntax error in CONSTRAINT clause. It appears correct to me. What may be the error in the constraint clause.
CREATE TABLE COMPUTER(
SerialNumber Number NOT NULL,
Make Text(12) NOT NULL,
Model Text(24) NOT NULL,
ProcessorType Text(24) NULL,
ProcessorSpeed Number NOT NULL,
MainMemory Text(15) NOT NULL,
DiskSize Text(15) NOT NULL,
primary key(SerialNumber),
CONSTRAINT MAKE_CHECK (Make IN ('Dell', 'Gateway', 'HP', 'Other')),
CONSTRAINT SPEED_CHECK CHECK(ProcessorSpeed BETWEEN 1.0 AND 4.0))
ms-access
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
add a comment |
0
I was running this SQL create table in access 2016 database but I get syntax error in CONSTRAINT clause. It appears correct to me. What may be the error in the constraint clause.
CREATE TABLE COMPUTER(
SerialNumber Number NOT NULL,
Make Text(12) NOT NULL,
Model Text(24) NOT NULL,
ProcessorType Text(24) NULL,
ProcessorSpeed Number NOT NULL,
MainMemory Text(15) NOT NULL,
DiskSize Text(15) NOT NULL,
primary key(SerialNumber),
CONSTRAINT MAKE_CHECK (Make IN ('Dell', 'Gateway', 'HP', 'Other')),
CONSTRAINT SPEED_CHECK CHECK(ProcessorSpeed BETWEEN 1.0 AND 4.0))
ms-access
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
1
Possible duplicate of Check Constraints in Access
– Erik von Asmuth
Nov 14 '18 at 12:28
Plus what Gustav said, but I consider that a typo since the second line shows you do know the correct syntax
– Erik von Asmuth
Nov 14 '18 at 12:28
add a comment |
0
0
0
I was running this SQL create table in access 2016 database but I get syntax error in CONSTRAINT clause. It appears correct to me. What may be the error in the constraint clause.
CREATE TABLE COMPUTER(
SerialNumber Number NOT NULL,
Make Text(12) NOT NULL,
Model Text(24) NOT NULL,
ProcessorType Text(24) NULL,
ProcessorSpeed Number NOT NULL,
MainMemory Text(15) NOT NULL,
DiskSize Text(15) NOT NULL,
primary key(SerialNumber),
CONSTRAINT MAKE_CHECK (Make IN ('Dell', 'Gateway', 'HP', 'Other')),
CONSTRAINT SPEED_CHECK CHECK(ProcessorSpeed BETWEEN 1.0 AND 4.0))
ms-access
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
I was running this SQL create table in access 2016 database but I get syntax error in CONSTRAINT clause. It appears correct to me. What may be the error in the constraint clause.
CREATE TABLE COMPUTER(
SerialNumber Number NOT NULL,
Make Text(12) NOT NULL,
Model Text(24) NOT NULL,
ProcessorType Text(24) NULL,
ProcessorSpeed Number NOT NULL,
MainMemory Text(15) NOT NULL,
DiskSize Text(15) NOT NULL,
primary key(SerialNumber),
CONSTRAINT MAKE_CHECK (Make IN ('Dell', 'Gateway', 'HP', 'Other')),
CONSTRAINT SPEED_CHECK CHECK(ProcessorSpeed BETWEEN 1.0 AND 4.0))
ms-access
ms-access
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
asked Nov 14 '18 at 12:14
MIRTYMIRTY
12
12
1
Possible duplicate of Check Constraints in Access
– Erik von Asmuth
Nov 14 '18 at 12:28
Plus what Gustav said, but I consider that a typo since the second line shows you do know the correct syntax
– Erik von Asmuth
Nov 14 '18 at 12:28
add a comment |
1
Possible duplicate of Check Constraints in Access
– Erik von Asmuth
Nov 14 '18 at 12:28
Plus what Gustav said, but I consider that a typo since the second line shows you do know the correct syntax
– Erik von Asmuth
Nov 14 '18 at 12:28
1
1
Possible duplicate of Check Constraints in Access
– Erik von Asmuth
Nov 14 '18 at 12:28
Possible duplicate of Check Constraints in Access
– Erik von Asmuth
Nov 14 '18 at 12:28
Plus what Gustav said, but I consider that a typo since the second line shows you do know the correct syntax
– Erik von Asmuth
Nov 14 '18 at 12:28
Plus what Gustav said, but I consider that a typo since the second line shows you do know the correct syntax
– Erik von Asmuth
Nov 14 '18 at 12:28
add a comment |
1 Answer
1
active
oldest
votes
1
Use the correct syntax:
CONSTRAINT MAKE_CHECK CHECK(Make IN ('Dell', 'Gateway', 'HP', 'Other')),
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53300010%2faccess-database-2016-syntax-error-in-constraint-clause%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Use the correct syntax:
CONSTRAINT MAKE_CHECK CHECK(Make IN ('Dell', 'Gateway', 'HP', 'Other')),
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
add a comment |
1
Use the correct syntax:
CONSTRAINT MAKE_CHECK CHECK(Make IN ('Dell', 'Gateway', 'HP', 'Other')),
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
add a comment |
1
1
1
Use the correct syntax:
CONSTRAINT MAKE_CHECK CHECK(Make IN ('Dell', 'Gateway', 'HP', 'Other')),
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
Use the correct syntax:
CONSTRAINT MAKE_CHECK CHECK(Make IN ('Dell', 'Gateway', 'HP', 'Other')),
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
answered Nov 14 '18 at 12:27
GustavGustav
29.6k51734
29.6k51734
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53300010%2faccess-database-2016-syntax-error-in-constraint-clause%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Possible duplicate of Check Constraints in Access
– Erik von Asmuth
Nov 14 '18 at 12:28
Plus what Gustav said, but I consider that a typo since the second line shows you do know the correct syntax
– Erik von Asmuth
Nov 14 '18 at 12:28