1. Forum
  2. Usenet
  3. COMP.DATABASES.MYSQL

  • Constraints

    From Dave@21:1/5 to All on Tue Jan 12 11:21:52 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jerry Stuckle@21:1/5 to Dave on Tue Jan 12 18:07:43 2021
    On 1/12/2021 11:21 AM, Dave wrote:
    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

    What storage engine are you using?

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    jstucklex@attglobal.net
    ==================

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)