Using GUID Column in ERD

GUID (Global Unique Identifier) is a special type of identifier in Microsoft SQL Server, which commonly use for generate unique value for key columns. You can specify column as GUID through the Entity Relationship Diagram (ERD). The steps for specify GUID column is quite simple:

1. Specify MS SQL Server as default database server of the project
2. Specify the datatype of primary key column as uniqueidentifier
3. Change the ID Generator of the primary key column as GUID

The following flash movie demonstrate how to specify the primary key column as GUID.