How to Generate Unique ID for Model Elements

ID is a very useful property for a model elements. Having an unique ID for your model elements not just can ease the communication between your team but also help to structure your model in a more systematic way. Visual Paradigm can help you to generate unique ID for your model elements. Besides, you can apply customized patterns to the ID to accommodate your needs in different situations. In this article, we will show you how to configure the ID generator to generate customized ID for your model elements with Visual Paradigm. Read more

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.