How to install the Unique property for the attribute (or columns) in ERwin database model?

Comments

1 comment

  • Avatar
    Jason Shangold
    • TheovanWestrienen

      Correct, no such check box exists in ERwin.

      You define Uniqueness in ERwin using a key group (logical diagram) or index (physical diagram).

      On that level you also indicate how you want to implement uniqueness (depending on which DBMS you use) via constraint and/or index.

       
      1 person found this helpful
      • andrei.tlt

        Thank you, it works! 

        Tried: shaped key group, got kind of script

        CREATE TABLE [Customer]

        ...

        ALTER TABLE [Customer]

                      ADD CONSTRAINT [XAK1Customer] UNIQUE ([DicontCard]  ASC)

        Execution of this script in Microsoft SQL Server Management Studio gives the same result as the previous script, formed in a different system design - new key and new index.

         
    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk