Knowledge Base DeZign for Databases
Constraints
Data modeling
- About Primary Keys and auto increment columns
- Check constraint benefits
- Primary key data type propagation
- Identifying and non-identifying relationships
- Store images in the database
- Data type for storing rich text format (RTF)
- My database does not support domains. Can I still use them?
- How can I create a VARCHAR(MAX) field?
- MS SQL Server Data Type TEXT or VARCHAR?
Database Objects
- How to implement an auto increment column in MS Access?
- Autoincrement Primary Key for Oracle
- Auto increment Primary Key for InterBase
- Copying entities
- Primary key data type propagation
- Keywords in default values
- Merging projects
- About Min and Max values for Oracle databases
- How do I move an attribute in the list of attributes?
- How can I define the MySQL table type?
- Ordering stored procedures
- Selecting related tables
- My database does not support domains. Can I still use them?
- How can I define my storage parameters?
- What are domains?
Miscellaneous
- Activating the software
- Can I export the model to XML?
- Import an ERwin data model
- Merging projects
- How to compare a data model with a database?
- How many entities can a diagram/project hold?
- About reserved words
- Data type for storing rich text format (RTF)
- Are the projects compatible between the editions?
- Using the BigQuery STRUCT data type
Reusable objects
Database modification
Diagrams
Printing and reporting
Reverse engineering
- How to connect to an Oracle database?
- How to connect to a Snowflake database?
- How to connect to a Google BigQuery database?
- Connecting to a remote MySQL server
- Import an ERwin data model
- How to make a MS SQL Server structure dump?
- How to make a MySQL structure dump?
- How to compare a data model with a database?
- How to make a DB2 structure dump?
Version control