Column Constraints - ER Diagram Syntax

  • NULL or NOT NULL keyword to specify the column is optional
  • IDENTITY keyword to indicate the column is incremental field
  • DEFAULT() keyword to specify the default value
CustomerID int PK IDENTITY
Name string DEFAULT('NA')
Address1 string NOT NULL
Address2 string NULL
Address3 string NULL