Defining Tables - ER Diagram Syntax

  • Simply type the table name followed by a hyphen and then type in your fields
  • Append any schema names. eg. ecommerce.Customer
  • If the table name has spaces, enclose it in double quotes. eg. "Customer Address"

Customer
-
CustomerID int
Name varchar(100)
Address1 string
Address2 string
City string