Posts

How to Find Out What Version of SQL Server You Are Using

Visual Paradigm supports data modeling with ERD and a set of engineering features like the reverse engineering and generation of database. The features are related with each other. For example, you may generate a database from physical ERD. In order to construct a data model that helps you build a database properly, you need to name the entities and their columns properly. Besides, data types of columns should be well-considered. Just to take the type ‘char’ example, there are quite a number of similar types like varchar, varchar2, nvarchar, etc. If a wrong type is chosen for any column, you may get data corruption or result in data lost.

Read more