TO understand

quick ref

select

perm control (DCL)

comment

-- one-line

/*multi-line*/

type

type[ prop[ …]]

option

not null

primary key

auto_increment

foreign key references tab(colName)

foreign key (col) references …

unique

check (vendors differ: https://www.w3schools.com/sqL/sql_check.asp)

default DEF_VAL