Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Create an ER Model and Add a Table

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

1. Select New Model2. Select Vendor3. Create New Table4. Double click  Table5. Set Table Properties6. Table Added7. Add More Tables

Create Relationships

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

    8. New Table Added9. Right-click on Table10. Select New Relationship11. Set Relationship Properties12. Relationship added13. Right-click Constraints14. Enter Constraints Properties

Create Primary Key Constraints, Indexes and Generate a Script from the Model

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

15. New Primary Key added16. Right-click Indexes17. Enter Index Properties18. Index is created19. More
Relationships
Constraints, Indexes &
Tables
20. Select Generate Script21. Select Schemas

View the Script Generation Status, View the script and further modify the diagram

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

22. Specify Script Name23. Script Generation Status24. Generated SQL Script25. Diagram Region added

...

A Model Generated from the Schema Browser "ER Diagram Generator"

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

1. Right-Click Choose "ER Diagram
Generator"
2. Select Schema Objects3. View Status4. Diagram Generated

...