Defining Tables - ERDL 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



Customer

-

CustomerID int

Name varchar(100)

Address1 string

Address2 string

City string