Enum TableConstraint 

pub enum TableConstraint {
    PrimaryKey {
        name: Option<String>,
        columns: Vec<String>,
    },
    Unique {
        name: Option<String>,
        columns: Vec<String>,
        nulls_not_distinct: bool,
    },
    Check {
        name: Option<String>,
        expr: Expr,
    },
    Index {
        name: Option<String>,
        columns: Vec<String>,
    },
}

v7.9.18 — table-level constraint at the end of a CREATE TABLE column list. Either a composite PRIMARY KEY or a UNIQUE (single- or multi-column).

Variants

PrimaryKey

PRIMARY KEY (col1, col2, ...). Implies NOT NULL on each referenced column. Engine builds a BTree index named <table>_pkey and enforces composite uniqueness on INSERT.

Fields

name: Option<String>

columns: Vec<String>

Unique

UNIQUE (col1, col2, ...). Engine builds a BTree index named <table>_<leading_col>_key (single-column) or <table>_<leading_col>_<…>_key (composite) and enforces uniqueness on INSERT.

Fields

name: Option<String>

columns: Vec<String>

nulls_not_distinct: bool

v7.13.0 — NULLS NOT DISTINCT modifier (mailrs round-5 G10). PG 15+ flips the NULL handling so any number of NULL rows collide on the constraint. Default is false (NULLS DISTINCT, standard SQL behaviour).

Check

v7.13.0 — CHECK (<expr>) table-level constraint (mailrs round-5 G3). Column-level inline CHECKs fold into this same variant at parse time. Engine evaluates the predicate against each INSERT/UPDATE candidate row; a false / NULL result rejects the mutation.

Fields

name: Option<String>

expr: Expr

Index

v7.15.0 — MySQL KEY name (cols) / INDEX name (cols) non-unique secondary-index declaration inline in CREATE TABLE. Engine builds a BTree index on the leading column (composite columns parse but only the leading column is honoured at v7.15 — matches the existing CreateIndexStatement::extra_columns semantics). Useful for mysql/blog-style schemas that lean on routine secondary indexes for ORM lookups.

Fields

name: Option<String>

columns: Vec<String>

Trait Implementations

impl Clone for TableConstraint

fn clone(&self) -> TableConstraint

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for TableConstraint

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for TableConstraint

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for TableConstraint

fn eq(&self, other: &TableConstraint) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for TableConstraint