Defining Columns - ERDL Diagram Syntax
- Each table field must be defined on a separate line in the following format: "FieldName datatype".
- Followed by column constraints (such as data type, PK, FK, UNIQUE, INDEX, IDENTITY, DEFAULT, NOT NULL, NOTE) may follow in any order.
- If the field name has spaces, enclose within double quotes. eg. "Customer Name"
Customer
-
CustomerID int PK
Name varchar(100)
Address1 string
Address2 string
City string
Post Comment