Knowledge Base DeZign for Databases

Constraints

• How to implement an auto increment column in MS Access?
• Autoincrement Primary Key for Oracle
• Auto increment Primary Key for InterBase
• Check constraint benefits
• Remove all constraint names

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?

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

• Can I export the model to XML?
• Import an ERwin data model
• Merging projects
• How many entities can a diagram/project hold?
• About reserved words
• Data type for storing rich text format (RTF)

Reusable Objects

• Benefits of using domains
• My database does not support domains. Can I still use them?
• What are attribute packages?
• What are domains?

Database Modification

• Why is the Alter database menu/button disabled?

Diagrams

• Unable to change the fonts of attributes using the Format menu
• Copying entities
• How can I delete an object from a subdiagram only?
• Display extra information on the model such as NULL option and datatype
• Export an image of the data model
• Exporting large diagrams as image

Printing and Reporting

• Export an image of the data model
• Exporting large diagrams as image
• Can I export the model to XML?

Reverse Engineering

• How to connect to an Oracle database?
• Connecting to a remote MySQL server
• How to make a DB2 structure dump?
• Import an ERwin data model
• How to make a MS SQL Server structure dump?
• How to make a MySQL structure dump?

Version Control

• About version types

Workspace

• Restore toolbars, object browser and messages window