Constraints
Dave <[email protected]> Tue, 12 Jan 2021 11:21:52 -0500
| Newsgroups | comp.databases.mysql |
|---|---|
| Organization | Aioe.org NNTP Server |
| Message-ID | <[email protected]> |
What is the advantage to the CONSTRAINT clause vs constraints in the
table/field definition? For example:
CREATE TABLE "Phone Number" (
"Phone ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
PRIMARY KEY,
"Patient ID" INTEGER NOT NULL,
"Number" VARCHAR(10),
"Description" VARCHAR(10),
CONSTRAINT FK_PAT_PHN FOREIGN KEY ("Patient ID") REFERENCES "Patient" ("ID
Number")
);
Seems to add no real functionality, but who knows.
Dave